Forum Discussion

saumitra's avatar
saumitra
Helper I
3 years ago
Solved

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

6 Replies