calculate with 5 filters simultaneous

[jppuam]

Hello,

i'm trying to implement a measure but i've to filter with 4 ou 5 criterias.

The filter in calculate only accepts 2 arguments. How can i make this ?

thanks,

JR

[v-xiaotang]

Hi @jppuam 

https://docs.microsoft.com/en-us/dax/filter-function-dax

you can try this, e.g.

Measure = CALCULATE(SUM('Table'[Sales]),FILTER(ALL('Table'),'Table'[Date]>=DATE(2021,4,1) && 'Table'[Region]="Region2" && 'Table'[Status] in {"Status1","Status3"}))

result

Best Regards,

Community Support Team _Tang

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

[jppuam · Accepted solution]

Hello,

i've reached a solution. What i've done is use the switch to contain all the formulas of the metrics and create a general metric that gives all the values.

Thanks for the help,

JR

[v-xiaotang]

Hi @jppuam 

thanks for your reply, could you close this thread by kindly accept the answer helpful as the solution. so the others can find it more quickly.

if you have question later, you can also add question in this thread or create a new one.

really appreciate!

Best Regards,
Community Support Team _Tang

[Greg_Deckler]

@jppuam In the filter param of CALCULATE use commas to separate your filter statements or use FILTER( ... ).