Forum Discussion

zenisekd's avatar
zenisekd
Icon for Super User rankSuper User
1 year ago

Calculation with multiple OR conditions

Hi, I was wondering, what is the most elegant solution, to write a measure, that contains multiple OR conditions over several related tables.  I have the following to work with: measure SALES (ca...
ThxAlot's avatar
ThxAlot
Icon for Super User rankSuper User
1 year ago

Follow this pattern to solve OR logic among different slicers,

= CALCULATE(
    SUM( tb[sales] ),
    FILTER(
        CROSSJOIN( ALL( slc1[col] ), ALL( slc2[col] ), ALL( slc3[col], slc3[_col] ) ),
        slc1[col] IN { } || slc2[col] IN { } || slc3[col] IN { } || slc3[_col] IN { }
    )
)

 

I assume you've got enough DAX knowledge to fit the pattern in your real-life scenario.