How to repeat measure value for all the rows

[SravaniG]

Hi,

I have a measure which gives week 1 value always, but i need to repeat the value in all the rows.

PFB screenshots for reference.

My result:

Expected result:

Thanks in advance.

[Tahreem24 · Accepted solution]

@SravaniG  - Try out this measure:

SALES MEASURE = CALCULATE(SUM(TableA[Sales]),ALL(TableA))

Screen shot attached for your reference:

[v-alq-msft · Accepted solution]

Hi, @SravaniG 

Based on your description, I created data to reproduce your scneario. The pbix file is attached in the end.

Sales Measure:

Sales Measure = 
IF(
    MAX('Table'[Store])="s1",
    2
)

You may create a new like below.

New Sales Measure = 
SUMX(
    ADDCOLUMNS(
        ALL('Table'),
        "Result",
        IF(
            [Store]="S1",
            2
        )
    ),
    [Result]
)

Result:

Best Regards

Allan

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Tahreem24 · Accepted solution]

@SravaniG  - Try out this measure:

SALES MEASURE = CALCULATE(SUM(TableA[Sales]),ALL(TableA))

Screen shot attached for your reference:

[amitchandak]

@SravaniG , This seems like both for store and week

try measure like

calculate([sales], all(Table) )

or

calculate([sales], all(Table[week]), all(Table[Store] ))