Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Project dashboard

Hi - I am attempting to create a dashboard that allows a user to compare the company value in each region with a stacked column chart. I've attached an image of what I am trying to do from an Excel w...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi Anonymous ,

    So you want to get the reverse of selected value and display on the total side?
    If this is a case, I'd like to suggest you use values and except function to get the reverse of selected value, then you can simply do aggregate and absolute on these values.

    DAX EXCEPT function 

    If you confused about coding formula, please share some dummy data with a similar data structure for test.

    Regards,

    Xiaoxin Sheng

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi Anonymous ,

So you want to get the reverse of selected value and display on the total side?
If this is a case, I'd like to suggest you use values and except function to get the reverse of selected value, then you can simply do aggregate and absolute on these values.

DAX EXCEPT function 

If you confused about coding formula, please share some dummy data with a similar data structure for test.

Regards,

Xiaoxin Sheng