Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
Anonymous
Not applicable

Matrix - Perform division

Hi, pretty new to Power BI

this is my sample data:

shiyam123_0-1643700076029.png

I created a matrix out of the same which looks something like this: 

shiyam123_1-1643700210832.png

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?

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

vjaneygmsft_0-1644288833885.png

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.

vjaneygmsft_2-1644289782150.png

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

 

 

View solution in original post

4 REPLIES 4
Anonymous
Not applicable

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

shiyam123_0-1643707775495.png

 

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

 

Don't forget to give thumbs up and accept this as a solution if it helped you!!!

Please take a quick glance at newly created dashboards : Restaurant Management Dashboard , HR Analytics Report , Hotel Management Report, Sales Analysis Report , Fortune 500 Companies Analysis , Revenue Tracking Dashboard

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

vjaneygmsft_0-1644288833885.png

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.

vjaneygmsft_2-1644289782150.png

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

@ Try this Measure DAX:

Total Record =
VAR _Total = SUM(MyTable[Record])
RETURN DIVIDE(_Total,7)
 
Don't forget to give thumbs up and accept this as a solution if it helped you!!!

Please take a quick glance at newly created dashboards : Restaurant Management Dashboard , HR Analytics Report , Hotel Management Report, Sales Analysis Report , Fortune 500 Companies Analysis , Revenue Tracking Dashboard

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.