Incorrect total in measure

[kavimk]

Sales = If (amt <0, amt+5, amt-5)
result:

Geo      amt     sales

India     15     10

japan   -10   -5

total      5     0 

here grant total is incorrect
expected O/P

1. we have to fix the incorrect total
2. it should work whatever user selecting any limit not limited one it could be multiple fields also instead of Geo

[Daniel29195]

@kavimk 

your measure -->  Sales = If (amt <0, amt+5, amt-5)

now create a new measure also : 

additive sales =  sumx(values(tbl_name[col_name]), [Sales])

let me know if it works for you .

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! 🤠

[kavimk]

this will be work but i want this part dynamically "values(tbl_name[col_name]". user wants to select any field 

[Daniel29195 · Accepted solution]

@kavimk 

https://www.youtube.com/watch?v=6rgAkejrup8

[Daniel29195]

@kavimk 

this video will help you with your problem .