Forum Discussion
Measure to add Boolean values
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))Syndicate_Admin so it worked on the previous table but not when you added months to the rows?
If yes, so it's because the way it calculate in the combination of months and style. In the total there is no filters, so I guess the style has values in different months, but I would also expect to see this in the visual. Very hard to say without looking at the model itself.
Where does the column month come from? The same table?
