Forum Discussion
Solved
Percentage in Piechart
Hello, I'm facing an issue with my pie chart. I have two different values. The 11 million is a part of the 61 million. So, the 61 million represents the whole amount, and the 11 million is specifical...
Hi Elijabrnc
You need 2 measures :
1 from the part that you want to show its dominance.Main value = CALCULATE(sum('Table'[value]),'Table'[column]="value 1")
2 for "others" :
If this post helps, then please consider Accepting it as the solution to help the other members find it more quicklydiff from all =CALCULATE(SUM('Table'[value]),'Table'[column]="value total")-[Main value]Result :
Hi Elijabrnc
You need 2 measures :
1 from the part that you want to show its dominance.
Main value = CALCULATE(sum('Table'[value]),'Table'[column]="value 1")
2 for "others" :
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
2 for "others" :
diff from all =
CALCULATE(SUM('Table'[value]),'Table'[column]="value total")-[Main value]
Result :