cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Advocate II
Advocate II

Is possible to show One Metric with details and rest simple by using Dax functions ?

Hello,

I need to show measures dynamically in Grid or Matrix visual, I have a set of data with over 20+ Metrics precalculate in SQL.

Those measures come from different Fact tables and it is with tabular data.

Based on from audience request I am looking to see if can be possible to do this: Using Dynamic Slicer show in the front one measure with some extra analisis (frame in blue) then keep showing the rest of the other measures simple as thier value come.

I am be able to change dynamically the blue frame but I wondering if it is possible to show the rest of the measures.

I am looking to do it in DAX but let please know if this can be done under Dax or under Query Editor but my preference is under dax.

 

For example from the slicer metric selection I choose metric A.
This one show all the details related variance, vol, vol% , impact, etc. but then rest of the metrics not select show next the metric selected it.

cluster.1590531736.png

 

Then if Metric B is select show the details and rest of the metrics simple.(metric b is back wit rest of the metrics)

cluster.1590531839.png

If the Metric c is select the that change in the blue frame and now metric B and metric A are back wit the rest of the metrics

Apprecite your advice and guide.

3 REPLIES 3
Highlighted
Solution Specialist
Solution Specialist

Re: Is possible to show One Metric with details and rest simple by using Dax functions ?

You can look at this:

https://community.powerbi.com/t5/DAX-Commands-and-Tips/Chart-of-Accounts-Totalling/m-p/1135767#M1692...

 

Put the columns (that are specified in a separate table) in a hierarchy. Put this hierarchy in a slicer to determine what is shown in the display. 

 

Please mark as solution if this is what you are looking for.

 

Kind regards,

 

 

Steve. 

Highlighted
Advocate II
Advocate II

Re: Is possible to show One Metric with details and rest simple by using Dax functions ?

 

thanks but.. mmm not sure if this will work... because I need in the same table not spliting in two tables.

Doing two tables separate will run the risk that one side of the table does not brings value for one agent...it  will not visible in the one of the table at be separate.
What I need to think is to pickup the value from the metric selection and storage in a variable where It will be the one be exclude from the metric list..

 

 

 

Highlighted
Solution Specialist
Solution Specialist

Re: Is possible to show One Metric with details and rest simple by using Dax functions ?

I have difficulty understanding your requirements.

Helpful resources

Announcements
Super Users of the Quarter - Q2 2020

Super Users of the Quarter - Q2 2020

Who are our Super User Superstars? Who made it to the top of the leaderboards? Get the answers!

June 2020 Community Highlights

June 2020 Community Highlights

Featured community members, changes to the Community, and more! Read up on recent Power BI community news.

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Power Platform 2020 release wave 2 plan

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors