row Subtotal not correct

[vjnvinod]

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

[Daniel29195 · Accepted solution]

@vjnvinod 

modify the code to this : 

sumx( 

values(tbl_name[team_name_col_name]) , 

calculate( 

       max(  QC_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! 🤠

[danextian · Accepted solution]

Hi @vjnvinod

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

[Daniel29195 · Accepted solution]

@vjnvinod 

modify the code to this : 

sumx( 

values(tbl_name[team_name_col_name]) , 

calculate( 

       max(  QC_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! 🤠