Forum Discussion
Matrix - Display totals based on visual values
For the Matrix table, I pulled this sentence from microsoft Power BI website.. "When you look at totals and subtotals, remember that those values are based on the underlying data. They aren't solely based on the visible values." Is there a way to display the totals based solely on the visible values not the underlying data or is there another visual similiar to the matrix that will provide this information? The totals are correct for the row but not the column
7 Replies
- Hi Anonymous,
You need to use the sumx based on the ALLSELECTED.
Something similar to:
SUMX ( ALLSELECTED (Table [Column] );SUM( Table[Column]) )
The column on the all selected should be the column used for the rows details in the matrix.
Regards,
MFelixThank you MFelix for you quick feedback. We are trying to add multiple columns so the measure you provided did not support addition of multiple columns.
Another note, we are trying to take the absolute value for each row on the visual and sum them to find the total deviation.
The numbers on total deviation do not add up to the subtotal. Instead, they add up to the row total.
Hi Anonymous ,
Can you share a sample data and expected result so that I can give you a more exact answer?
Thank you.
Regards,
MFelix
