Multiple filters calculate funtion

[Emmy88_]

Hi all,

Still a dax newbie, does anyone know the function for the following:

Measure for a matrix for accounts including

• all accounts with volume 0-80k, all products
• Except products wo-40 and wo-50 with a volume of 40 -80k

I want to use the calculate function, but not sure how to combine different volume filters for different product groups.

Thank you!

Emmy

[Ashish_Mathur]

Hi,

Share some data and show the expected result.

[Emmy88_]

Hereby a simple example. 

I would like to build a measure showing all volume for all products from all clients with more than or equal to 60. Except for product a i would also like to show volume if sold 50 or more.

I have tried the underneath measure but it does not work unfortunately:

[Ashish_Mathur]

Hi,

I do not understand your question.  Someoe who does will help you.

[lbendlin]

Shipped = sumx(Filter('Table','Table'[Volume]>=60 || 'Table'[Product]="a" && 'Table'[Volume]>=50 ),[Volume])

[lbendlin]

Filters are applied on top of each other.  Power BI observes Boolean math.

Calculate (something,

volume <=80k,

product not in list (wo-40,wo-50) or volume <40k

)

[Emmy88_]

I tried your measure with one of the products i would like to make an exception for with lower volume, however it does not show the right outcome. What am i doing wrong?