Total for customerMax field

[csb]

Hello,

  I need help to get in below matrix Total for customerMax field by adding all the values in that field,but right now it is giving me max value in that column(as I am considering max value in the entire field ,total is also showing max value) which is not what I need.I need to add all the max values of customermax  and show it in the total field.

 As shown below Total should be 

1275000

Thanks..

[Ashish_Excel · Accepted solution]

Hi,

This DAX measure pattern should work

Measure = SUMX(VALUES(Data[Row field]),[Max_measure])

To receive any further help, share the download link of the PBI file.  Show the expected result there.

[grazitti_sapna · Accepted solution]

Hi @csb 

Try using below dax measure for total sum of all the values:

CustomerMaxSum =
SUMX(
VALUES('Table'[Customer]),
CALCULATE(MAX('Table'[Value]))
)

🌟 I hope this solution helps you unlock your Power BI potential! If you found it helpful, click 'Mark as Solution' to guide others toward the answers they need.
💡 Love the effort? Drop the kudos! Your appreciation fuels community spirit and innovation.
🎖 As a proud SuperUser and Microsoft Partner, we’re here to empower your data journey and the Power BI Community at large.
🔗 Curious to explore more? [Discover here].
Let’s keep building smarter solutions together!

[v-pnaroju-msft · Accepted solution]

Thank you, @Ritaf1983 , @Ashish_Excel , and @grazitti_sapna , for your responses.

Hi @csb,

We appreciate your inquiry posted on the Microsoft Fabric Community Forum.

Please find attached the screenshot and the PBIX file which may assist in resolving the issue:

If you find our response helpful, kindly consider marking it as the accepted solution and providing kudos. This will help other community members who might have similar queries.

Should you have any further questions, please feel free to contact the Microsoft Fabric Community.

Thank you.

[csb]

Thank you.This works.Can you please suggest tool where DAX can be understood ,practised and debugged

with examples for beginners.

[grazitti_sapna · Accepted solution]

Hi @csb 

Try using below dax measure for total sum of all the values:

CustomerMaxSum =
SUMX(
VALUES('Table'[Customer]),
CALCULATE(MAX('Table'[Value]))
)

🌟 I hope this solution helps you unlock your Power BI potential! If you found it helpful, click 'Mark as Solution' to guide others toward the answers they need.
💡 Love the effort? Drop the kudos! Your appreciation fuels community spirit and innovation.
🎖 As a proud SuperUser and Microsoft Partner, we’re here to empower your data journey and the Power BI Community at large.
🔗 Curious to explore more? [Discover here].
Let’s keep building smarter solutions together!

[Ashish_Excel · Accepted solution]

Hi,

This DAX measure pattern should work

Measure = SUMX(VALUES(Data[Row field]),[Max_measure])

To receive any further help, share the download link of the PBI file.  Show the expected result there.

[Ritaf1983]

Hi @csb 

In Power BI, the total row in a matrix doesn't work like in Excel. It doesn't just add the numbers shown above — it recalculates the same expression (like MAX) in a broader context, ignoring row-level filters.

That's why you're seeing only 700,000 in the total for Max of CustomerMax. Power BI is calculating the overall MAX across all divisions, instead of summing each division's MAX.

To fix this, you need a DAX measure that behaves differently in row vs. total:

DAX


CustomerMaxFixed :=
IF(
ISINSCOPE('YourTable'[Division_Code]),
MAX('YourTable'[CustomerMax]),
SUMX(
VALUES('YourTable'[Division_Code]),
CALCULATE(MAX('YourTable'[CustomerMax]))
)
)

Replace 'YourTable' with your actual table name.

Show the sum of those max values in the total row — which is what you expect (1,275,000).

To get more accurate help, please consider uploading your .pbix to a public cloud folder (like OneDrive, Google Drive, or WeTransfer) and sharing the link.

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly