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