Filter DAX table with slicer

Hi I have created a DAX table as below, but it won't filter out the table based on the slicer selection.

May i know how it could be acheived ?

amitchandak
Super User
4 years ago
vijayvizzu , if you are creating a new table and try to use slicer value, then it will not work
vijayvizzu
Helper III
4 years ago
Thanks amitchandak , but the purpose of this post is to know any other alternate way to achieve it
- amitchandak
  Super User
  4 years ago
  vijayvizzu , We usually add a table as Var in measure and use that. This table should respond to slicers
  
  But wait for other user responses too
  
  Measure =
  
  Vat _tab = <Table Script>
  
  return
  
  sumx(_tab, [Value])
Anonymous
Not applicable
4 years ago
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.

Forum Discussion