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.
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.