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
Sean's avatar
Sean
Icon for Community Champion rankCommunity Champion
10 years ago

Visual Level Filters - can be both columns and measures!

 

What is your Measure formula?

 

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