Forum Discussion
Grouping Measures
Hi Everyone,
I have a Revenue, Projections and Targets table, for which I have created 3 simple DAX Measures.
1. Revenue = sum(Revenue [invoice_amount])/10^5
2. Target = sum(Targets [target])/10^5
3. Projections = sum(Projections [projections])/10^5
I would like to club these into a group say - PAT, wherein I can drill up or drill down as required.
Currently my headers look this way:
However, I would want it to be like a +/- situation, where I can hide the measures if I click on the minus sign or show measures if I click on + sign.
The idea is to be able to show and hide as required.
Is there any way this can be done?
Any ideas would be appreciated.
Regards,
Saumitra
saumitra , Please explore field parameters or calculation groups
Calculation Groups- Measure Slicer, Measure Header Grouping, Measure to dimension conversion. Complex Table display : https://youtu.be/qMNv67P8Go0
6 Replies
- AnonymousNot applicable
Hi,
I think this similar thread is discussing the solution you are looking for:
https://community.powerbi.com/t5/Desktop/Slicer-to-hide-or-unhide-measures-in-a-line-chart/m-p/1147352#M520805- saumitraHelper I
Hi,
I couldn't understand how it will show all 3 measures together if nothing is selected? Kindly please explain. Thanks!
- amitchandakSuper User
saumitra , Please explore field parameters or calculation groups
Calculation Groups- Measure Slicer, Measure Header Grouping, Measure to dimension conversion. Complex Table display : https://youtu.be/qMNv67P8Go0