Forum Discussion
CROSSFILTER without match
Hello, I'm using a simple cross filter on the tables below. However, not all my products are matching for the three tables (Some appear only in Z_BOMS, other only in Ventes, etc..). This returns an e...
DataInsights
Super User
Super UserAnonymous,
Why are you using the CROSSFILTER function? Not sure why you would need to pass filter context from Z_BOM to Ventes, since they share the dimension table Produits.
Hello, I tried to simply the example to make it easy to understand, but I'm going to have other columns my result table (# Commande and Ventes from Ventes, Date from Dates, MP and Qté from Z_BOM_Explosé). So the blank rows multiply and I have a rather large dataset so I get millions of useless rows.
Thank you