SUM RESULTS SWITCH FORMULA

[rdiazd73]

Hello guys
thanks in advance for your help 🙂

I have an table with 2 country and 2 cost, ok

I created a switch formula for using slicer etc, and change indpendence of country , ok no prob funcionality ok

_PAL $ = SWITCH(TRUE();

[_PALET COST BY COUNTRY]="ES10";FORMAT([TOTAL PALETS]*VALUES('COUNTRY PALET COST'[COST]);"$0,00");

[_PALET COST BY COUNTRY]="PT03";FORMAT([TOTAL PALETS]*VALUES('COUNTRY PALET COST'[COST]);"$0,00"))

the problem appear when I would like  obtain the total cost for  all countrys, is posible added line to swich formula 

for obtain the total cost for 2 countrys together ?  thank you

[V-lianl-msft]

Hi @rdiazd73 ,

You could try something like this:

_PAL $
=SWITCH([_PALET COST BY COUNTRY], 
"ES10",FORMAT([TOTAL PALETS]*VALUES('COUNTRY PALET COST'[COST]);"$0,00"),
"PT03",FORMAT([TOTAL PALETS]*VALUES('COUNTRY PALET COST'[COST]);"$0,00"),
 [total cost for 2 countrys]
 )  

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[rdiazd73]

thank you @V-lianl-msft 

sorry don´t working well, 

[V-lianl-msft]

Hi @rdiazd73 ,

I mean, you need to write the [total cost for 2 countries] calculation formula there. Maybe you could share the sample pbix so that I can understand your scenario better.

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

Try something like this

sumx(summarize(Table,Table[Location Id],"_1",[_PAL $]),[_1])

[Greg_Deckler]

This looks like a measure totals problem. Very common. See my post about it here: https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dealing-with-Measure-Totals/td-p/63376

Also, this Quick Measure, Measure Totals, The Final Word should get you what you need:
https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/m-p/547907