Forum Discussion

carlenb's avatar
carlenb
Icon for Advocate II rankAdvocate II
2 years ago
Solved

DAX Multiple column matches? Model attached

Hi,   I have a Sales table from 2019 to 2022 with sales volume, sales date and suppliers. See model here: https://drive.google.com/file/d/1ie-tNNGnjq2jvL54EP1bJF2xWKNMK3AU/view?usp=sharing   Pr...
  • some_bih's avatar
    some_bih
    2 years ago

    Hi carlenb please try measure below (include possible filtering on column Projekt)

    Sales Total Measure =
    VAR __Table_sum =
        SUMMARIZE (
            'Sales2019-2022',
            [Sales date],
            [Supplier],
            [Supplier ID],
            [Article],
            "__SalesVolume", SUM ( [Sales volume] )
        )
    VAR __Result_sum =
        SUMX ( __Table_sum, [__SalesVolume] )
    RETURN
        IF (
            ISFILTERED ( DimProject[Projekt] ),
            __Result_sum,
            SUM ( 'Sales2019-2022'[Sales volume] )
        )

     

some_bih's avatar
some_bih
Icon for Community Champion rankCommunity Champion
2 years ago

Hi carlenb please try measure below (include possible filtering on column Projekt)

Sales Total Measure =
VAR __Table_sum =
    SUMMARIZE (
        'Sales2019-2022',
        [Sales date],
        [Supplier],
        [Supplier ID],
        [Article],
        "__SalesVolume", SUM ( [Sales volume] )
    )
VAR __Result_sum =
    SUMX ( __Table_sum, [__SalesVolume] )
RETURN
    IF (
        ISFILTERED ( DimProject[Projekt] ),
        __Result_sum,
        SUM ( 'Sales2019-2022'[Sales volume] )
    )

 

carlenb's avatar
carlenb
Icon for Advocate II rankAdvocate II
2 years ago

Fantastic, thanks a lot some_bih for your patience 🙂