Forum Discussion
Matrix - Perform division
Hi, pretty new to Power BI this is my sample data: I created a matrix out of the same which looks something like this: I have to perform a division on the Total column as in I want th...
Hi, Tahreem24
You can't use matrix table and only show two totals in it at the same time.
What can be done:
If you only need to change total to total record and nothing else.
You can create a measure to modify total.
Like this:
Total Record = VAR _Total = SUM ( Table[No of records] ) RETURN IF ( SELECTEDVALUE ( Table[Month] ) <> BLANK (), _Total, DIVIDE ( _Total, 7 ) )If you need to show two totals, you need to use table visual, so you need to pivot column to get the matrix table in pq, then you can create two measures to show total and total records.
Did I answer your question? Please mark my reply as solution. Thank you very much.
If not, please feel free to ask me.
Best Regards,
Community Support Team _ Janey
@ Try this Measure DAX:
Total Record =
VAR _Total = SUM(MyTable[Record])
RETURN DIVIDE(_Total,7)