Forum Discussion
Solved
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 Calc...
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 🙂
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.@SpartaBI I have been presented with an error, the fault is not identified. in cases such as the following example the total value is incorrect.
I have successfully added the code.
Countable = SUMX(VALUES('Style by Make'[Assembly Style]),Where _Budget = Calculations[Budget]Where _Shipping = Calculations[Shipping]Return if(_Budget>_Shipping,_Shipping,_Budget))
