topic Measure not Filtering Calculation in DAX Commands and Tips

Measure not Filtering Calculation

Anonymous — Wed, 27 Oct 2021 05:55:48 GMT

Hi people, I'm just hitting against a wall with this one.

I have a calculate function in DAX where I want to sum a column:

Soldadura =
CALCULATE (
SUM ( WM[Diámetro Neto] ),
FILTER ( WM, WM[FECHA SOLDADURA (UNION)] > [Fecha Corte Media] )
)

Where

- [Diámetro Neto] and [FECHA SOLDADURA (UNION)] are columns in my fact table, first one format is a number and the 2nd one is a date

- [Fecha Corte Media] is a measure from a Date minus a parameter which is a integer

The above expresion does the sum, but it is not filtering so I get the total, and I don't know why

If I substitute [Fecha Corte Media] by a DATE(YYYY,MM,DD), it works fine, also, a very similar expresion in a different table works fine:

Festivos desde Corte =
CALCULATE (
    COUNT ( Festivos[Festivos] ),
    FILTER (
        Festivos,
        Festivos[Festivos] > [Fecha Corte Media]
            && Festivos[Festivos] <= [Fecha Actualización]
    )
)

Re: Measure not Filtering Calculation

Fowmy — Wed, 27 Oct 2021 06:49:10 GMT

Anonymous

Not enough information about the model and the calculation, check your relationships and the current filter context where you are running this measure. Can you try the following version?

Soldadura = var __fecha = [Fecha Corte Media] Return CALCULATE ( SUM ( WM[Diámetro Neto] ), WM[FECHA SOLDADURA (UNION)] > __fecha )

Re: Measure not Filtering Calculation

v-yanjiang-msft — Tue, 02 Nov 2021 06:11:31 GMT

Hi Anonymous ,

According to your description, I create a sample and the result works fine, I think it is possible that the type and writing of the measure “Fecha Corte Media” cause your problem.

Best Regards,
Community Support Team _ kalyj

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

Re: Measure not Filtering Calculation

Anonymous — Wed, 03 Nov 2021 13:35:59 GMT

Actually, I modify the DB structure to simplify it and now it works. I was making a mistake, probably because the relationship between the data and where the measuere was coming from.