Forum Discussion
Solved
Incorrect total in measure
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 i...
Daniel29195
Community Champion
Community Champion
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! 🤠
this will be work but i want this part dynamically "values(tbl_name[col_name]". user wants to select any field
- Daniel29195
- Daniel29195