Dynamic Hiding Row Measures based on Slicers Selection

[Anonymous]

HI I have the below requirement.

The slicer will dynamically update the Below report.

THanks,

RamsK

[v-xuding-msft]

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]

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

[ramshoney1225]

It's not resolved mybproblem

[Anonymous]

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]

Any Suggession please?