Total for customerMax field

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.

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!

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.