Forum Discussion
Help with matrix table measures
.
Greg_Deckler
Community Champion
Community ChampionAnonymous OK, see PBIX attached below signature. The basic measure is:
Total = "Wins - " & SUM('sample'[WIGS_Wins_Achieved])+0 & ", Target - " & SUM('sample'[WIGS_Target])+0 & ", " & FORMAT([%]+0, "0.00") & "%"
Greg_Deckler Thank you so much for this. Can we also show the AMs count with the wins, target and percentage?
- Greg_Deckler
Anonymous I don't see why not. Updated PBIX below that also shows this in a matrix visual.
Total = "Wins - " & SUM('sample'[WIGS_Wins_Achieved])+0 & ", Target - " & SUM('sample'[WIGS_Target])+0 & ", " & FORMAT([%]+0, "0.00") & "%, AMS - " & [ams]Greg_Deckler in the sample pbix file, the first table has total right. Can we have this measure which looks like the row subtotals? so that even if we expand the hierarchy, the new measure which represents the total should also be placed accordingly like this:
Is this possible?
- Greg_Deckler
Anonymous I don't understand what you are saying.