Forum Discussion

maxime325's avatar
maxime325
Regular Visitor
3 years ago

Different result in matrix

Hello, Could you have any idea how is this possible ? I don't have the same total result if I switch columns and lines in this matrix, without changing anything else. Thank you for your help   ...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
3 years ago

maxime325 , Please share the measure?

 

If measure is like divide([m1], [m2]) , then it should work

maxime325's avatar
maxime325
Regular Visitor
3 years ago

Thank you, here is the measure : 

 

Rapport base = DIVIDE(CALCULATE(AVERAGE('Datas Winter'[Yield]),FILTER('Datas Winter','Datas Winter '[Hub_code]=HUB1[Valeur HUB1])),CALCULATE(AVERAGE('Datas Winter '[Yield]),FILTER('Datas Winter ','Datas Winter '[Hub_code]=HUB2[Valeur HUB2])))