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
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