Need to repeat a specific row value for all rows in column

[mk5235]

Hi All,

I am working with a table, x_Market, that has a list of retailers, channels, and total market rows which is linked to a data table, x_Data, with SUM measure of sales data (Sales).

One row value is "All Stores", and I am trying to create a measure that will repeat this row value for all rows as below:

Market	Sales	Desired Result
All Stores	4,528,190	4,528,190
Store 1	434,762	4,528,190
Store 2	318,158	4,528,190
Store 3	342,994	4,528,190
Store 4	317,825	4,528,190
Store 5	408,956	4,528,190
Store 6	313,063	4,528,190
Store 7	128,337	4,528,190
Channel 1	1,413,739	4,528,190
Channel 2	850,356	4,528,190

Can anyone help with this? 

Thanks!

[vicky_ · Accepted solution]

you can use something like the formula below to grab just the sales for one row:

desired result = CALCULATE(SUM('Table'[Sales]), ALL('Table'[Store]), 'Table'[Store] = "A")