Forum Discussion
Solved
Create metric with same value based on specific row
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 Unite...
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.
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"
)