Forum Discussion
Percentage based on specific row
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
Thank you AlB
In the full dataset, the column "COUNTRY" will only contain the country's name. Which then "ALL-ALL" will be just the total of every country. In that case, we don't need "ALL-ALL", "ALL-ASIA", "ALL-EUROPE".
However, it will make the size of the database will be very huge given that the commodity is at least 300 products.
Here, the filter Country : ALL-ALL will only dictate the denominator.
ALL-ALL >> divide by 200
ALL-ASIA >> divide by 80
While the filter "Status - State", will limit the name of the country and not "ALL-ALL", "ALL-ASIA", etc.
Best
angsoka
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