Understanding CALCULATE in DAX: Filters

very well explained, thank you very much for these insights into this function

This was great,, thank you! Also, I am trying to do something similar. I have 2 tables, T1= all orders. T2= errors. I need to calculate the percentage of errors for each client(where the list is in the thousands) based on the client name, and then filter by date. The logic I came up with was :

error percentage = calculate[count(order errors) / count(total orders)] , CUSTOMER NAME CONDITION , but I am not quit sure how to do the syntax. Any help would be greatly appreciated!

or if you have a more elegant solution I will take it too!

Thank you!

How can I use OR with a filter instead of AND?

What do you do if you want to filter 2 color?

Thank you so much . When am I going to get a breakthrough on Filters ? I understand everything but can’t write it free flow like you and other pros .In order for me to get to that level I need to understand it as much as I understand 2+2= 4. Otherwise all I do now for complex filter Daxes is copy and paste.

Good introduction and well explained as ever, here it comes, I would have liked to see
the 'long' syntax for the two table filter, as i think that's better when learning how things actually work together. BTW loved the fibonacci sequence.

Very handy and useful

Thanks

Great tutorial. Thanks :-)

Great explanation.