Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Dynamic Hiding Row Measures based on Slicers Selection

HI I have the below requirement.

The slicer will dynamically update the Below report.

 

 

THanks,

RamsK

Need Help

5 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Any Suggession please?

  • v-xuding-msft's avatar
    v-xuding-msft
    Icon for Community Support rankCommunity Support
    7 years ago

    Hi Anonymous ,

    It can't be implemented in single table. I created a sample with a new irrelative table you can have a try.

    Measure = 
VAR a = SELECTEDVALUE('Table'[KPI]) 
VAR b = CALCULATE(SUM(Table1[Values]),FILTER('Table1',Table1[Name] = "BM Top" || Table1[Name] = "Successful"||Table1[Name]="UnSuccess"|| Table1[Name]="BestRate"))
VAR c =  CALCULATE(SUM(Table1[Values]),FILTER('Table1',Table1[Name] = "TNTR" || Table1[Name] = "RRTR"))
return
IF(a = "SSLR" || a = "DSLR" || a = "DDPR" ,b,IF( a = "DX" || a = "AX", c,SUM(Table1[Values])))

    I have attached my sample below you can download.

     

    Best Regards,

    Xue Ding

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Hi,

       

      Thankyou so much for the response, but first 3 measures are one fact, and the other two measures are in differnt fact. 

      can i go ahead with replacing the table names in the logic? and let you know.

       

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      HI,

       

      I have downloaded the PBIX file and seen, it was good.

       

      But, Actually in my case i need to elobarte more its my wrong, The KPI list have 5 Values 

      what ever the measure im showin in Table view are not column values , its all are different 5 measures.

       

      Table 1: with Quarter, and 4 Measues and those 4 measures works with first 3KPI values.

      Table 2: with Quarter and 2 measures and those 2 measures works with last 2 KPI values.

       

      as the above, i said i dont want to put every thing into 1 table ( Quarter, 6 Measusres ) bec if i put them together i will see nulls for alternative meausre. which i dont want . 

       

      based on first 3 KPI values which i select from drop down works on only 4 measures with other graaphs..

      based on last 2 KPI values when i select from dropdown works on only 2 measures with other graph.

       

      I'm not able to achive that.

       

      THanks for you response

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago
        It's not resolved mybproblem