topic Re: Filter Measure (From Quick Measure) in DAX Commands and Tips

Filter Measure (From Quick Measure)

NDRS — Fri, 09 Feb 2024 15:05:58 GMT

Hi,

I've done some quick measures to filter values, but when I check the Measure against the filter it only return the total sum, not per filter or what to say. Is it possible to fix this?

This is the DAX:

Kost.belopp (aktuellt) for 18, 6, or 1 =

CALCULATE(

SUM('Artikeltransaktion (2)'[Kost.belopp (aktuellt)]),

'Artikeltransaktion (2)'[Lagerställekod] IN { "18", "6", "1" }

)

So in this case I want to see the value per [Lagerställekod] 1, 6 and 18.

I want it to return the value like this (But without 85XX):

Have a nice friday all!

Re: Filter Measure (From Quick Measure)

Jihwan_Kim — Fri, 09 Feb 2024 15:08:33 GMT

Hi,

Please try something like below if it suits your requirement.

Kost.belopp (aktuellt) for 18, 6, or 1 = CALCULATE ( SUM ( 'Artikeltransaktion (2)'[Kost.belopp (aktuellt)] ), FILTER ( 'Artikeltransaktion (2)', 'Artikeltransaktion (2)'[Lagerställekod] IN { "18", "6", "1" } ) )

Re: Filter Measure (From Quick Measure)

NDRS — Fri, 09 Feb 2024 15:21:16 GMT

Awesome! Thanks 🙂