Forum Discussion
Helper ISUM RESULTS SWITCH FORMULA
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
5 Replies
- Greg_Deckler
Community Champion
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 - amitchandak
Super User
Try something like this
sumx(summarize(Table,Table[Location Id],"_1",[_PAL $]),[_1])
V-lianl-msftCommunity Support
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- 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.
