Reversing the relationship direction for a single DAX measure (CROSSFILTER?)

[Shortmeister1]

Hi

I've got a growing table as listed below. I also have created a very simple data model schema as below.

The eagle eyed among you will notice that I have reversed the relationship from the incident fact table to the calendar table so that I can pick up all dates which accounts for "Cat0"

So to put it in context, a typical measure will look like this:

=CALCULATE(
    COUNTROWS(fIncident),
    fIncident[Cat] = 1
    )

whereas Cat0 looks like this:

=CALCULATE(
    COUNTROWS('Calendar'),
    ISBLANK( fIncident[Cat]),
    CROSSFILTER(fIncident[Date], 'Calendar'[Date], OneWay)
    )

I've been trying to use CROSSFILTER to avoid having to reverse the Calendar relationship, but it's not working unless the relationship is left "backwards". In fact, it changes all of the other measures.

Anyone got any great suggestions on how to use CROSSFILTER properly in this scenario?

Thanks
Martin

 

[JEC]

Changing OneWay to Both maybe?

 

[Shortmeister1]

Tried it. Made no difference.