Forum Discussion

av9's avatar
av9
Icon for Helper III rankHelper III
5 years ago

Crossfilter with multiple fact tables

Hi  I am looking to get some advice on the best way to proceed with this model.   I believe my 2 options are :  1) Use DAX Crossfilter function 2) Turn on bi-directional filtering (i.e. Both) in...
Need Help
av9's avatar
av9
Icon for Helper III rankHelper III
5 years ago

I want to be able to filter the matrix by the status. So in the screenshot 1 if I pick the slicer it should remove rows I marked in red. I can achieve this by using bi-directional filter but want to get some advice if this is the right way to go or should I use DAX.

 

this is what it should look like:

 

 

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi av9 ,

 

You can set the value is not blank in Filters.

 

 

Best Regards,

Stephen Tao

 

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

  • av9's avatar
    av9
    Icon for Helper III rankHelper III
    5 years ago

    Thanks, it probably doesnt show in this example report but I also have some customers who have blank as there preference. 

     

    So even when I apply this filter and slicer it filters the column but the ones that are blank still show.

     

    Crossfilter example