Forum Discussion
gmat
2 years agoHelper I
Matrix Total Line Representation
I'm currently working on a PowerBI project where I've constructed a matrix representing various categories of our unique identifiers, denoted by numbers displayed on the far left. Within this matrix,...
- 2 years ago
gmat See attached PBIX.
Measure = IF( HASONEVALUE('Table'[Class]), SUM('Table'[Revenue]), SUMX(ALL('Table'), [Revenue]))
Greg_Deckler
2 years agoCommunity Champion
gmat See attached PBIX.
Measure = IF( HASONEVALUE('Table'[Class]), SUM('Table'[Revenue]), SUMX(ALL('Table'), [Revenue]))gmat
2 years agoHelper I
Great, thanks so much. I had to tweak the formula a bit to take into account all of the other filters but it worked!