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

noumanqaiser's avatar
noumanqaiser
Advocate I
7 years ago

Hello,

 

Any of the solutions provided here donot work. I am not sure why this is marked as resolved. As far as I understand, dynamic values of measures that change on the front end due to user applying filters o the UI do not affect calculated tables/columns in any way. I tried using all methods specified here but it seems calculated Tables/Calculated columns are directly evaluated based on base context in the underlying data.