Measure to add Boolean values

[Syndicate_Admin]

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

Calculations[Budget]>Calculations[Shipping],Calculations[Shipping],Calculations[Budget]

but I can't get the total sum of countable

This is the code I have used.

countable =

IF(HASONEVALUE('Style by Make'[Assembly Style]),

Where P=

SWITCH(

True (),

Calculations[Budget]>Calculations[Shipping],Calculations[Shipping],

Calculations[Budget]

)

Return P

)

Someone who helps me with ideas, I will thank you eternally.

[Syndicate_Admin]

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.

[SpartaBI · Accepted solution]

@Syndicate_Admin 

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_Admin]

A worked to perfection! Thank you so much.

[SpartaBI]

@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.

[Syndicate_Admin]

@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]

@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?