Forum Discussion

MED_D's avatar
MED_D
Regular Visitor
2 years ago

Matrice Power BI

Bonjour je travaille sur une matrice , bien que j'ai deux colonnes avec des valeurs différentes au niveau des lignes mais le totale  de la colonne ‘Valeur nette fin.’ A un montant différent de ‘Vale...
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi MED_D ,

 

It is possible that the problem is caused by the use of certain filters in the formulas. Compare the following two formulas, their totals are the same, but the totals in category a are different.

M1 =
IF (
    HASONEVALUE ( 'Table'[Category] ),
    CALCULATE ( SUM ( 'Table'[Value] ), FILTER ( 'Table', 'Table'[Pro] <> "a1" ) ),
    SUM ( 'Table'[Value] )
)

M2 = SUM('Table'[Value])

 

 

Best Regards,
Adamk Kong

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.