Forum Discussion
KWelsh8144
Helper II
Helper IICalculation 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
Community Champion
Community ChampionKWelsh8144 Try right-clicking the measure in the field well and choose Show As and then Percent of total
KWelsh8144Helper II
Helper IIWhen 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.