Forum Discussion
Help with mesure
Hi!
I´m having some issues with the total amount of a mesure.
The calculation I want to get done is, if the sum of some columns for a particular ID is >200, display 200, but if not, show me the sum of those columns.
So I have:
MyMesure = IF(SUMX(Table,Table[Column1]+Table[Column2])>200, 200, SUMX(Table,Table[Column1]+Table[Column2]))
The thing is that in a table, the formula will show the correct calculation por each ID, but for the total will do the sum of both column 1 and 2 -200.
Can anyone help me?
Anonymous add a measure and use it in your visuals
New Measure = SUMX ( VALUES ( Table[Id] ), [MyMeasure] )I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!
⚡Visit us at https://perytus.com, your one-stop shop for Power BI related projects/training/consultancy.⚡
1 Reply
Anonymous add a measure and use it in your visuals
New Measure = SUMX ( VALUES ( Table[Id] ), [MyMeasure] )I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!
⚡Visit us at https://perytus.com, your one-stop shop for Power BI related projects/training/consultancy.⚡