Calculate function does not seem to lift the filter it is supposed to lift

[Steph_Piret]

Hello Everyone,

I don't understand why the result of this "calculate" formula only shows when the filter is applied. I thought it was supposed to repeat the same constant on all the rows from the table. Has someone an idea?

I would like to repeat the "GRP" from the North next to the "GRP" results of all the other targets.

I've build this formula :

GRP MAT North =

CALCULATE([Monthly GRP Views MAT], FILTER(Targetlist, Targetlist[Target]="North"))

The result is ok :  GRP MAT North = GRP MAT when the target filter is "North" BUT the result does not appear on the other rows for some reason:

thanks a lot for helping

[Steph_Piret · Accepted solution]

I found a solution : it works if I use "allselected", like suggested in this other post:

Solved: calculate function - Microsoft Power BI Community

Thank you for making me think of "all" anyway!

[Jos_Woolley]

It does for me using the data you provided, though perhaps you could confirm the definition for your Monthly GRP Views MAT measure? Failing that, you can either upload your workbook or, if that's not possible (e.g. due to confidentiality reasons), it should be fairly easy for you to create a small, mocked-up version which uses dummy data and upload that.

Regards

[Jos_Woolley]

Hi,

GRP MAT North =
CALCULATE ( [Monthly GRP Views MAT], Targetlist[Target] = "North" )

which is equivalent to:

GRP MAT North =
CALCULATE (
    [Monthly GRP Views MAT],
    FILTER ( ALL ( Targetlist[Target] ), Targetlist[Target] = "North" )
)

Regards

[Steph_Piret]

Thanks but unfortunately it does not change the result I get ...