Forum Discussion
Syndicate_Admin
Administrator
AdministratorMeasure 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 🙂
Syndicate_AdminAdministrator
Administrator@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))
SpartaBI
Community Champion
Community ChampionSyndicate_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?