Forum Discussion
Measure to add Boolean values
Hello everyone
I have this case without finding a correct solution, I have two measures that add budget and shipping, I need to another extent meet a condition and add the total result
countable = SUMX( VALUES('Style by Make'[Assembly Style]), VAR _budget = Calculations[Budget] VAR _shipping = Calculations[Shipping] RETURN IF ( _budget > _shipping, _shipping, _budget ) )
In case it answered your question please mark this as a solution for community visibility. Appreciate Your Kudos 🙂
6 Replies
countable = SUMX( VALUES('Style by Make'[Assembly Style]), VAR _budget = Calculations[Budget] VAR _shipping = Calculations[Shipping] RETURN IF ( _budget > _shipping, _shipping, _budget ) )
In case it answered your question please mark this as a solution for community visibility. Appreciate Your Kudos 🙂A worked to perfection! Thank you so much.
Syndicate_Admin my pleasure 🙂
Please don't forget to mark that reply as a solution to help other community members find it more easily. Appreciate Your Kudos.
Hello, I hope you are well,
in the model there is a calendar table, I want to show you the comparison of the result of the model vs calculated in excel, do you have any suggestions to modify the initial code?
Greetings, thank you for your contribution.
