Forum Discussion

MP_123's avatar
MP_123
Icon for Microsoft Employee rankMicrosoft Employee
10 years ago

filter on a measure

hi i 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 somethin...
Need Help
MP_123's avatar
MP_123
Icon for Microsoft Employee rankMicrosoft Employee
10 years ago

MP_123's avatar
MP_123
Icon for Microsoft Employee rankMicrosoft Employee
10 years ago

Sean

the option to change the 'is less' is disabled...

and can enter data or apply

 

this is the formula:

Card Type Avg.3 = if(HASONEVALUE(Query1[Experience]), calculate(([Click Rate]),all(Query1[Experience])))

  • MP_123's avatar
    MP_123
    Icon for Microsoft Employee rankMicrosoft Employee
    10 years ago

    hi,

     

    is someone can help me?:smileyhappy:

    • 5TimeGrandpa's avatar
      5TimeGrandpa
      Frequent Visitor
      8 years ago

      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???