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
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

av9 , what you want to filter , say if you want customers from transaction that has newsletters

 

 

countx(values(customer[customer]), if(not(isblank([newsletter measure])) && not(isblank([transaction measure])) , [customer], blank())

 

So what you wnat to get here, please let us know.

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