Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 |
---|---|
101 | |
90 | |
80 | |
71 | |
69 |
User | Count |
---|---|
114 | |
97 | |
97 | |
73 | |
72 |