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: