cancel
Showing results for
Did you mean:

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Impactful Individual

## row Subtotal not correct

Hi All,

I am  using a simple measure as below

Tar WTD = MAX(QC_WTD[TargetDax WTD])

as you can see below my row total is also showing the max value, ideally this should be sum of 318, 1219 and so on, not sure why the row total is not coming up correctly

2 ACCEPTED SOLUTIONS
Super User

modify the code to this :

sumx

values(tbl_name[team_name_col_name]) ,

calculate

maxQC_WTD[TargetDax WTD] )
)
)

let me know if this helps .

If my answer helped sort things out for you, i would appreciate a thumbs up 👍 and mark it as the solution
It makes a difference and might help someone else too. Thanks for spreading the good vibes! 🤠

Super User

@Daniel29195 already  gave you the solution but here's why are not seeing the expected value in the total:

Each row in your visual returns the respect max value of QC_WTD[TargetDax WTD] based on the current value of Team Name but in your total, it returns the max value of QC_WTD[TargetDax WTD] for the whole table or at least based on slicer selections if there are.

Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

"Tell me and I’ll forget; show me and I may remember; involve me and I’ll understand."
Need Power BI consultation, get in touch with me on LinkedIn or hire me on UpWork.
Learn with me on YouTube @DAXJutsu or follow my page on Facebook @DAXJutsuPBI.
2 REPLIES 2
Super User

@Daniel29195 already  gave you the solution but here's why are not seeing the expected value in the total:

Each row in your visual returns the respect max value of QC_WTD[TargetDax WTD] based on the current value of Team Name but in your total, it returns the max value of QC_WTD[TargetDax WTD] for the whole table or at least based on slicer selections if there are.

Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

"Tell me and I’ll forget; show me and I may remember; involve me and I’ll understand."
Need Power BI consultation, get in touch with me on LinkedIn or hire me on UpWork.
Learn with me on YouTube @DAXJutsu or follow my page on Facebook @DAXJutsuPBI.
Super User

modify the code to this :

sumx

values(tbl_name[team_name_col_name]) ,

calculate

maxQC_WTD[TargetDax WTD] )
)
)

let me know if this helps .

If my answer helped sort things out for you, i would appreciate a thumbs up 👍 and mark it as the solution
It makes a difference and might help someone else too. Thanks for spreading the good vibes! 🤠

Announcements

#### Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

#### Power BI Monthly Update - April 2024

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

#### Fabric Community Update - April 2024

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

Top Solution Authors
Top Kudoed Authors