topic Re: Create metric with same value based on specific row in DAX Commands and Tips

Create metric with same value based on specific row

ElistheFox — Fri, 11 Nov 2022 08:53:00 GMT

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.

Re: Create metric with same value based on specific row

daXtreme — Fri, 11 Nov 2022 12:31:20 GMT

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" )

Re: Create metric with same value based on specific row

Anonymous — Mon, 14 Nov 2022 09:00:07 GMT

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.

Re: Create metric with same value based on specific row

Anonymous — Tue, 15 Nov 2022 06:28:03 GMT

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.