Forum Discussion
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 incorrect total
2. it should work whatever user selecting any limit not limited one it could be multiple fields also instead of Geo
4 Replies
- Daniel29195
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
