Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
hi everyone
I'm trying to calculate the percentage for the total of a column but i can't seem to be able to have a single mesure with the total of that column to divide each row with i keep ending up with the total of the row and not of the column
Mesure = SUM('Prenium n-2 BI'[n-1])
this give me the total if i put it on visual on it's own but i soon as try to put it with the rest of my data it get segregate and it's behaving the same way when i try to divide it by the number in my row with the following formula
sum N-1 = DIVIDE(SUMX('Prenium n-2 BI',[n-1]),[Mesure])*100
thanks in advance
Solved! Go to Solution.
Total = SUM(YourNumbers) %ofTotal = DIVIDE ( [Total] ; CALCULATE ( [TOTAL] ; ALL (YourTable) ) )
Try this
Total = SUM(YourNumbers) %ofTotal = DIVIDE ( [Total] ; CALCULATE ( [TOTAL] ; ALL (YourTable) ) )
Try this
thank you so much i've been struggling for like 2 hour on this
Most welcome, we've all been there - keep going
User | Count |
---|---|
98 | |
90 | |
77 | |
71 | |
64 |
User | Count |
---|---|
114 | |
97 | |
95 | |
68 | |
65 |