Filter Measure (From Quick Measure)

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? Th...

Jihwan_Kim

2 years ago

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" }
    )
)

Forum Discussion

Filter Measure (From Quick Measure)

Related content

Dynamic measure filtering

Filter by Rank measure

Measure

DAX Measure

Using measure as a filter