Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
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.
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.
Try something like this
sumx(summarize(Table,Table[Location Id],"_1",[_PAL $]),[_1])
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
111 | |
92 | |
84 | |
66 |