Matrix - Perform division

[Anonymous]

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 the values to be divided by 7 and display it as a new column. How do I have to approach this?

[Anonymous]

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

[Tahreem24]

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

[v-janeyg-msft · Accepted solution]

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

[Tahreem24]

@ Try this Measure DAX:

Total Record =

VAR _Total = SUM(MyTable[Record])

RETURN DIVIDE(_Total,7)