Forum Discussion

marakud's avatar
marakud
Frequent Visitor
3 years ago
Solved

DAX : SUM is wrong in matrix

Hi everyone,   I need your help for a calculation. I make this :   Sales = VAR _SALES = CALCULATE ( SUM ( 'Ca Réalisé'[Sales] ) ) VAR _SALES_NOPROD =     CALCULATE (         SUM ( 'Ca ...
Need Help
  • Ahmedx's avatar
    Ahmedx
    3 years ago

    pls try this

marakud's avatar
marakud
Frequent Visitor
3 years ago

I have observed that the issue stems from the ISFILTERED function, which considers the subcategories of the hierarchy as filtered rows. As a result, it always performs the first calculation based on the condition.

marakud's avatar
marakud
Frequent Visitor
3 years ago

how to solve this ?