Forum Discussion
Show Different Values According to the Hierarchy
Hi mussaenda!
I've tried this way but it didn't work. Drilling up, the visual just summed all th results above the hierarchy. But I used ISFILTERED and it worked!
This was the measure:
% Meta = IF(ISFILTERED('Target - State'[State]);CALCULATE(SUM('Target - State'[Done])/SUM('Target - State'[Target]);ALLEXCEPT('Target - State';'Target - State'[State]));IF(ISFILTERED('Target - State'[Country]);CALCULATE(SUM('Target - State'[Done])/AVERAGE('Target - State'[Target Country]);ALLEXCEPT('Target - State';'Target - State'[Country]));""))
Community ChampionHi mussaenda!
The data are confidential, but I've attached a Sample and a .xlsx where the same idea may be applied.
There are 2 databases. I wish to plot on a stacked bar chart an acompaniment of the target %.
My axis hierarchy is Country > State. There are different values for the %target of the countries and states and I expect the correct value to be shown as I drilldown. In the .xlsx file, the columns % Target State / % Target Country shows the expected output.
gdoss wrote:Hi mussaenda!
The data are confidential, but I've attached a Sample and a .xlsx where the same idea may be applied.
There are 2 databases. I wish to plot on a stacked bar chart an acompaniment of the target %.
My axis hierarchy is Country > State. There are different values for the %target of the countries and states and I expect the correct value to be shown as I drilldown. In the .xlsx file, the columns % Target State / % Target Country shows the expected output.
Couldn't send the files here (don't know why) but the files are in this link https://forumpowerbi.com/viewtopic.php?f=8&t=2722&p=6018#p6018 (is a brazilian forum for Power BI)
- mussaenda