Filter DAX table with slicer

Hi vijayvizzu 

Please check the expression in the second half of your filter to see if there are conditions that contain all the content, causing your other filter conditions to not take effect. Or when you need to generate DAX queries dynamically through code. It is recommended to add the filter directly to the SUMMARIZECOLUMNS filter parameter. For example :

I found some introductions about SUMMARIZECOLUMNS() and SUMMARIZE() , hope it will help you have a better understanding about SUMMARIZECOLUMNS() and SUMMARIZE() .

http://umashanthan.blogspot.com/2017/04/how-to-use-summarizecolumns-function.html

https://www.sqlbi.com/articles/introducing-summarizecolumns/

Best Regard

Community Support Team _ Ailsa Tao

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