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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
Stabben23
Helper I
Helper I

Total sum in Matrix

Hi,

 

I need help to get correct total sum in my Matrix, this should be done in DAX.

I have Pcs in carton from one table on article level, this works on all rows. I need some filter (I guess) to filter out the value 3000 in my DAX. As it is now it calculate 86900/3000=290, thats wrong., it should sum up the rows instead.

Total_cartons.PNG

1 ACCEPTED SOLUTION
v-lili6-msft
Community Support
Community Support

hi @Stabben23 

This is a measure totals problem. Very common. See this post about it
https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dealing-with-Measure-Totals/td-p/63376
Also, this Quick Measure, Measure Totals, The Final Word should get you what you need:
https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/m-p/547907
 
For your case, you could try this way:
measure =
VAR _table =
    SUMMARIZE (
        'Table',
        'Table'[Customer Group],
        'Table'[Articles],
        "_Cartons", [Cartons]
    )
RETURN
    SUMX ( _table, [_Cartons] )
 
Regards,
Lin
Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

4 REPLIES 4
v-lili6-msft
Community Support
Community Support

hi @Stabben23 

This is a measure totals problem. Very common. See this post about it
https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dealing-with-Measure-Totals/td-p/63376
Also, this Quick Measure, Measure Totals, The Final Word should get you what you need:
https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/m-p/547907
 
For your case, you could try this way:
measure =
VAR _table =
    SUMMARIZE (
        'Table',
        'Table'[Customer Group],
        'Table'[Articles],
        "_Cartons", [Cartons]
    )
RETURN
    SUMX ( _table, [_Cartons] )
 
Regards,
Lin
Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

@v-lili6-msftthanks that you show me how to solve this kind of "measure total problem", very useful.

This is a must know for every developer, thanks again!

amitchandak
Super User
Super User

Share the formula created in dax. If possible please share a sample pbix file after removing sensitive information.
Thanks

Can share DAX, Not pbix file.

TotalPcs =calculate(sumx(OOLINE;[OBORQT]) *1000;OCUSMA[OKCUNO] <> "2172";OOHEAD[OAORTP] <>"CRU" ;OOLINE[OBORST] <"66")
Cartons = divide([TotalPcs];sum(MIZTL2[STKRT]);0)

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

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

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.