Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi,
Here is the report which showing values, I would like to calculate percentages of it.
ex: for Nov 2018 A = 32 , B = 24
Expected results A=57.14%, B= 42.85%
Please let me know how to solve this.
Thanks
Solved! Go to Solution.
You may use measure below.
Measure = DIVIDE ( SUM ( Table1[Count] ), CALCULATE ( SUM ( Table1[Count] ), ALLSELECTED ( Table1[Category] ) ) )
You may use measure below.
Measure = DIVIDE ( SUM ( Table1[Count] ), CALCULATE ( SUM ( Table1[Count] ), ALLSELECTED ( Table1[Category] ) ) )
Thank you very much. Thing it did the trick!
/U
Thank you so much.
User | Count |
---|---|
128 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |