Forum Discussion
Solved
Percentage based on specific row
Dear all, I want to create a measure on powerpivot which calculate the export percentage on specific rows. Below is the part of the data. ALL-ALL means that it is the total export of every country...
HI angsoka,
I'd like to suggest you take a look at the following links to know the hierarchy level and use selectedvalue and switch function to achieve dynamic calculations based on current value:
Clever Hierarchy Handling in DAX - SQLBI
Regards,
Xiaoxin Sheng
AlB
Community Champion
Community ChampionHow will you select ALL-ALL in the Country slicer and expect the table to show Indonesia and Thailand?
If you select ALL-ALL, the table will show ALL-ALL. You'll need to change the structure of your table
|
|
Please accept the solution when done and consider giving a thumbs up if posts are helpful. Contact me privately for support with any larger-scale BI needs, tutoring, etc. |