Forum Discussion
KWelsh8144
3 years agoHelper II
Calculation per row in matrix
What DAX would i use to calculate a percentage per row.. For example, the below screenshot, 4 in the first column/row, should say 30.77% (4/13).. and then the same for every number listed here wi...
Greg_Deckler
3 years agoCommunity Champion
KWelsh8144 Try right-clicking the measure in the field well and choose Show As and then Percent of total
- KWelsh81443 years agoHelper II
When i do that (percent of row total), it all shows as 100% Greg_Deckler
The calculated column that makes up 'not started' (just as one example) is
= if(Sheet1[*completefield] = 0, 1, 0)Then, in the matrix, i have it as a sum. When i switch to % by row, that's what happens.