Measure responds inconsistently when added to table

[JB]

I have a measure that calculates if an entry falls within a date range and, if it does, returns a 1.

However, when applied to a table it seems to be totally inconsistent. See below - all rows should return a 1

Any suggestions as to what is causing this discrepency would be appreciated. 

Thanks

Please note - this is a continuation from an unsolved thread here:
https://community.powerbi.com/t5/DAX-Commands-and-Tips/Measure-not-calculating-all-rows-on-a-table/m...

[v-chenwuz-msft]

Hi @JB ,

It is about the filter context.

Can you try just remove the CALCULATE( ... , CROSSFILTER()), just left IF(...)?

If 'Progress Services'[scaff reg / selected start date] is a measure, what does it looks like?

Or you can share some example data if you need more help.

Best Regards

Community Support Team _ chenwu zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[JB]

Removing Calculate and CrossFilter returns only 0s.

The measure is CALCULATE(max( [DATE] ), all('Slicer Calendar'))

[v-chenwuz-msft]

Hi @JB ,

Please share your pbix file without sensitive data. Not quite sure what the problem is, only by the description of the text.

[tamerj1]

Hi @JB 

would you please create a measure COUNTROWS ( 'Progress Services' ), place it in the table and advise what results you obtain? Thank you

[JB]

Hi, it just returns empty cells, doesn't produce anything. 

[tamerj1]

As long as you managed to set the relationship to one directional then you need to remove CALCULATE along with the CROSSFILTER part completely.

[JB]

Unfortunately that only returns 0s