Forum Discussion
Solved
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,...
gmat See attached PBIX.
Measure = IF( HASONEVALUE('Table'[Class]), SUM('Table'[Revenue]), SUMX(ALL('Table'), [Revenue]))
Hi Greg_Deckler , apologies for the lack of detail in my post. Below is a dataset that I have used to create the matrix in the following screenshot. What I am trying to do is keep the current selection of classes 30/40/50 but have the sum of units in the matrix = to total sum of all units (1450) and total sum of revenue in the matrix to be total sum of all revenue ($330,000).
| Class | Units | Revenue |
| 20 | 100 | $6,000 |
| 30 | 110 | $12,000 |
| 40 | 120 | $18,000 |
| 50 | 130 | $24,000 |
| 60 | 140 | $30,000 |
| 70 | 150 | $36,000 |
| 80 | 160 | $42,000 |
| 90 | 170 | $48,000 |
| 100 | 180 | $54,000 |
| 120 | 190 | $60,000 |
gmat See attached PBIX.
Measure = IF( HASONEVALUE('Table'[Class]), SUM('Table'[Revenue]), SUMX(ALL('Table'), [Revenue]))