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

2 Replies

    • 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])))