How to create a calculated measure to populate same value across different rows

[Snagalapur]

Hi All, 

Please suggest How to create a calculated measure to populate same value across different rows.

Currently i'm using below formula: 

Result =

CALCULATE(

    SUM('Table'[Value]),

    FILTER(

        'Table',

        'Table'[Type] = "B"

    )

)

Thank you.

[v-echaithra]

Hi @Snagalapur ,

We wanted to kindly follow up to check if the solution provided for the issue worked? or Let us know if you need any further assistance?
If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.

Regards,
Chaithra.

[v-echaithra]

Hi @Snagalapur ,

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided for the issue worked? or Let us know if you need any further assistance?
If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.

Regards,
Chaithra E

[v-echaithra]

Hi @Snagalapur ,

We wanted to kindly follow up to check if the solution provided for the issue worked? or Let us know if you need any further assistance?
If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.

Regards,
Chaithra.

[v-echaithra]

Hi @Snagalapur ,

Thank you for reaching out to Microsoft Community.

As you mentioned you have additional filters in view.

Your current formula using ALL('Table') removes all filters, including those from slicers or visuals, which is why it ignores their selections. To make the measure respect report filters/slicers, but ignore only the row context, you need to use REMOVEFILTERS or ALLSELECTED more selectively.

Try this DAX:

Result =

CALCULATE(

SUM('Table'[Value]),

FILTER(

REMOVEFILTERS('Table'[Type]), -- Removes only row-level context, keeps slicers

'Table'[Type] = "B"

)

)

If this post helps, please give us Kudos and consider marking it Accept as solution to assist other members in finding it more easily.

Regards,
Chaithra

[Deku]

This is not working in the calculated column because calculate turn the current row context into a filter context that limits the scope of the FILTER(), you need to remove that filter context with ALL

Result =
CALCULATE(
    SUM('Table'[Value]),
    FILTER(
        ALL('Table'),
        'Table'[Type] = "B"
    )
)

[Snagalapur]

I do have additional filters in view, which i may have to consider. Above solution brings Sum regardless of filters in view. Please suggest

[bhanu_gautam]

@Snagalapur To ensure that this value is populated across all rows, you should use a measure instead of a calculated column. Here is how you can create a measure that will give you the expected result:

DAX
Expected Result =
CALCULATE(
SUM('Table'[Value]),
'Table'[Type] = "B"
)