filter on a measure

Question

hii created new calculated measure.i want the measure to appear on report only if it's not blank.on the visual level filter, the option to change the settings of the filter from all to something else is disabled... (i think because there is no option on pbi to filter on a measure)is someone have an idea how to solve it?&nbsp;thanks!

sean · Answer

Visual Level Filters - can be both columns and measures!&nbsp;What is your Measure formula?&nbsp;

mp_123 · Answer

mp_123 · Answer

Seanthe option to change the 'is less' is disabled...and can enter data or apply&nbsp;this is the formula:Card Type Avg.3 = if(HASONEVALUE(Query1[Experience]), calculate(([Click Rate]),all(Query1[Experience])))

mp_123 · Answer

hi,&nbsp;is someone can help me?:smileyhappy:

5timegrandpa · Answer

I have the same issue and it's driving me nuts. I have 2 reports. One where I have a simple chart based on a measure, and a visual filter (a calculated measure) that works perfectly. I have a second report nearly identical but with a different simple chart (of the same type). The visual filter is the same exact calculated measure. On the second report, the apply filter is disabled, and I can't get it to apply? What is up with this Microsoft???

Forum Discussion

filter on a measure

5 Replies

Related content

Dynamic measure filtering

Filter by Rank measure

Using measure as a filter

Measure not affected by filter

DAX MEASURE TO FILTER