Forum Discussion
Visual Level Filter ignored by Measure
I have the below set up (see image). The 934 number is from a measure: _MeasureTotalSelected = COUNTROWS(VALUES(CUSTOMER)) It's obvious that the 934 does not correlated with the count of the ro...
HI Anonymous,
If you want to enable the visual level filter effect, you can try to combine use allselected and countrows functions.
For example:
_MeasureTotalSelected = COUNTROWS ( ALLSELECTED ( CUSTOMER ) )
BTW, I'm not so sure above formula works if you drag other table column as the filter of current visual.
Regards,
Xiaoxin Sheng
I have the same scenario and none of the above has worked.
I have two measures. One factors in the visual level filters and the other does not. Why is this?
Works with visual level filters:
Total Searches = COUNT('Usage Statistics'[ID])Does not work with visual level filters:
2017-06 = CALCULATE(COUNTROWS('Usage Statistics'), 'Usage Statistics'[Created] >= date(2017,06,01), 'Usage Statistics'[Created] < date(2017,7,01))Why does the first one factor in visual level filters but the second one does not?
Hello,
Does anybody get a solution for this issue?
Regards,
Parag