Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

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...
Need Help
Tips and Tricks
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hello, yes it's from the "Produits" table. Thank you 

DataInsights's avatar
DataInsights
Icon for Super User rankSuper User
3 years ago

Anonymous,

 

You could try testing for blank before performing the calculation:

 

Qté_MP =
IF (
    NOT ISBLANK ( [Ventes] ) && NOT ISBLANK ( [Qté_Bom] ),
    CALCULATE (
        [Ventes] * [Qté_Bom],
        CROSSFILTER ( Produits[Produit], 'Z_BOM_Explosé'[Produit], BOTH )
    )
)
  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hello, yes I already did but it wasn't working. Thank you

    • DataInsights's avatar
      DataInsights
      Icon for Super User rankSuper User
      3 years ago

      Anonymous,

       

      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.

      • Anonymous's avatar
        Anonymous
        Not applicable
        3 years ago

        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