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
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