Forum Discussion

gdoss's avatar
gdoss
Frequent Visitor
7 years ago
Solved

Show Different Values According to the Hierarchy

Hi everyone!   A friend told me that was possible but he didn't say how, that's why I'm here. I'm using a stacked bar chart and that's how it was plotted.   Axis: a 2 levels hierarchy Value: Tar...
Need Help
  • gdoss's avatar
    gdoss
    7 years ago

    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]));""))

     

     

     

mussaenda's avatar
mussaenda
Icon for Community Champion rankCommunity Champion
7 years ago

 

gdoss's avatar
gdoss
Frequent Visitor
7 years ago

mussaenda great!

 

About states ok! That's it. But what happens when I drill up? The sum will be just the sum of the states inside that country hierarchy, or are they a percentage of the Country - Target (that would be the right)?

 

thanks!

  • mussaenda's avatar
    mussaenda
    Icon for Community Champion rankCommunity Champion
    7 years ago

    hi gdoss ,

     

    Have you tried?

    The sum will show according to what you put inside the visual.

    Try it and you can also answer the question by yourself and see if it is showing right values.

     

    Do not forget to close the thread if your question has been solved.

    • gdoss's avatar
      gdoss
      Frequent Visitor
      7 years ago

      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]));""))