Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
I would like to get a % of each month to sum up to 100% instead of grand total.
What I have now:
When I change from numbers to % I have like this:
But I would like to have like this:
How can I get to this?
Solved! Go to Solution.
@Anonymous ,
You want overall %
divide([measure], calculate([measure], allselected())
or
for legend column
divide([measure], calculate([measure], filter(allselected(Table), Table[Legend column] = max(Table[Legend column] ))))
or
for legend month year
divide([measure], calculate([measure], filter(allselected(Table), Table[month year] = max(Table[month year] ))))
@Anonymous ,
You want overall %
divide([measure], calculate([measure], allselected())
or
for legend column
divide([measure], calculate([measure], filter(allselected(Table), Table[Legend column] = max(Table[Legend column] ))))
or
for legend month year
divide([measure], calculate([measure], filter(allselected(Table), Table[month year] = max(Table[month year] ))))
Thank you, it's working!
User | Count |
---|---|
123 | |
76 | |
63 | |
50 | |
50 |
User | Count |
---|---|
175 | |
125 | |
60 | |
60 | |
58 |