Forum Discussion

mohammedismail's avatar
mohammedismail
Helper I
8 years ago
Solved

Filter Table Data based on Dynamic Measure Value

Hi,   I have a Dynamic Measure which is created from the What If Parameter   The below is my Measure, where Parameter value is %   Measure = DISTINCTCOUNT([Supplier_Name])*Parameter[Parameter V...
Need Help
  • v-jiascu-msft's avatar
    v-jiascu-msft
    8 years ago

    Hi mohammedismail,

     

    1. It's [PercentValue] rather than [Percentage Value] in the formula.

    Measure = IF([Rank]<=CALCULATE([PercentValue], all(Sheet1)),1,BLANK())

    2. The Visual Level Filter should be "is not blank".

     

    Best Regards,

    Dale

mohammedismail's avatar
mohammedismail
Helper I
8 years ago

v-jiascu-msft Anonymous For some reason the Measure value is not being considered in the formula... If I remove the Measure 'Percent Value' and key in a Number it is working fine.. But when I enter the measure it is not working..

 

Appreciate your help.

v-jiascu-msft's avatar
v-jiascu-msft
Microsoft Employee
8 years ago

Hi mohammedismail,

 

Did you try my formula? It worked in the test file.

Filter_Table_Data_based_on_Dynamic_Measure_Value

 

 

 

Best Regards,

Dale

  • mohammedismail's avatar
    mohammedismail
    Helper I
    8 years ago

    v-jiascu-msft I did try.. I guess I'm doing something wrong ? PLease see the screenshot below and advice :)

     

     

     

     

    • v-jiascu-msft's avatar
      v-jiascu-msft
      Microsoft Employee
      8 years ago

      Hi mohammedismail,

       

      1. It's [PercentValue] rather than [Percentage Value] in the formula.

      Measure = IF([Rank]<=CALCULATE([PercentValue], all(Sheet1)),1,BLANK())

      2. The Visual Level Filter should be "is not blank".

       

      Best Regards,

      Dale