SUM fuction with filter

[judithnig]

Hi all,

I am new to DAX, so thanks for your patience 🙂

I am adding a screenshot here: I want to caclulate in DAX the % difference of "New" & "New to Partner" compared to "existing customers":

Thanks upfront, 

Judith

[Anonymous · Accepted solution]

Hi @judithnig ,

Please have a try.

Create a measure.

measure =
CALCULATE (
    SUM ( table[value] ),
    FILTER (
        ALL ( table ),
        table[column1] = "partner1"
            || table[column1] = "partner2"
    )
)

How to Get Your Question Answered Quickly 

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

Best Regards
Community Support Team _ Polly

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

[MFelix]

Hi @judithnig ,

What do you mean by filtering? Do you want your measure to always give the same result even when you use filters or slicers or do you want it to be dinamic?

DAX calculations are based on context so if you have a simple SUM and you have a filter of those columns the calculations will be presented correctly if you want to have it all the same then you need to do something similar to:

Sum metric = CALCULATE ( SUM(Table[Column]), Table[Partner1] = Value , Table[Partner2] = Value)

Replace value with the ones that you need.