topic Re: Calculate function does not seem to lift the filter it is supposed to lift in DAX Commands and Tips

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

Steph_Piret — Thu, 02 Sep 2021 13:53:51 GMT

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

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

Jos_Woolley — Thu, 02 Sep 2021 14:38:19 GMT

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

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

Steph_Piret — Thu, 02 Sep 2021 15:13:01 GMT

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

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

Jos_Woolley — Thu, 02 Sep 2021 15:18:29 GMT

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

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

Steph_Piret — Fri, 10 Sep 2021 07:57:01 GMT

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

Solved: calculate functio n - Microsoft Power BI Community

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