cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Ramshoney Frequent Visitor
Frequent Visitor

Dynamic Hiding Row Measures based on Slicers Selection

HI I have the below requirement.

The slicer will dynamically update the Below report.

 

QUery.png

 

THanks,

RamsK

5 REPLIES 5
Ramshoney Frequent Visitor
Frequent Visitor

Re: Dynamic Hiding Row Measures based on Slicers Selection

Any Suggession please?

Community Support Team
Community Support Team

Re: Dynamic Hiding Row Measures based on Slicers Selection

Hi @Ramshoney ,

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])))

2.PNG3.PNG4.PNG

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.

Ramshoney Frequent Visitor
Frequent Visitor

Re: Dynamic Hiding Row Measures based on Slicers Selection

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.

 

Ramshoney Frequent Visitor
Frequent Visitor

Re: Dynamic Hiding Row Measures based on Slicers Selection

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 Frequent Visitor
Frequent Visitor

Re: Dynamic Hiding Row Measures based on Slicers Selection

It's not resolved mybproblem

Helpful resources

Announcements
Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

Ask Amanda Anything Q&A

Ask Amanda Anything Q&A

Learn the answers to some of the questions asked during the Amanda Triple A event.

October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Solution Badges

New Solution Badges

Two waves of brand new solution badges are coming! Read the article for more information on our new community badges.

Users Online
Currently online: 320 members 2,431 guests
Please welcome our newest community members: