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

Anonymous,

 

Is your visual using the Produit field in the dimension table Produits? Visuals should use fields in dimension tables whenever possible.

  • 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