Forum Discussion
Matrix - Perform division
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
Hi, it is working but it seems to add up in every column values as a record in the matrix. Is there any way to show this as a single seperate column alone, like the TOTAL column
Anonymous I guess that's not possible to add like a Total which is inbuilt column from Martix visual itself. Otherwise take the Month column under Process type.
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
