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.
Dear PBI community,
In the picture below, I have a column with sum of total sales for all countries. I would like to add a NEW metric (for example Total Sales of USA) which will have value of United States sales on all rows. Consequently, I would create ANOTHER NEW metric and divide (result will be in %) column Total Sales of USA by column Total Sales. How am I able to achieve it with DAX?
Thanks a lot for your help, I have gone through some forum threads but I could not find answer for this specific challenge.
Solved! Go to Solution.
Hi @ElistheFox ,
If so, please create a measure based on the [usa sales].
measure=maxx(all(Sales Territory),[usa sales])
If it still does not help, please provide more details with your desired output and pbix file without privacy information.
Best Regards
Community Support Team _ Polly
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @ElistheFox ,
If so, please create a measure based on the [usa sales].
measure=maxx(all(Sales Territory),[usa sales])
If it still does not help, please provide more details with your desired output and pbix file without privacy information.
Best Regards
Community Support Team _ Polly
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks for your reply, however, it does not work. If I apply your formula, I will get result only on row with United States. But I need to see the same result on all rows. I´ve even tried to delete all filters but still, no progress.
This is such a basic thing to do in DAX that I don't believe you couldn't find it on the forum or even on YT. But nevertheless...
[USA Sales] =
CALCULATE(
[Total Sales],
'Sales Territory'[Sales Territory Country] = "usa"
)
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 |
---|---|
43 | |
20 | |
18 | |
16 | |
15 |
User | Count |
---|---|
49 | |
26 | |
22 | |
17 | |
16 |