Forum Discussion

JFV's avatar
JFV
Frequent Visitor
7 years ago
Solved

Total Avarage Wrong

Hi,   I created some simple pivot tables consisting of e.g. Revenue, Number of Visit and Avarage Revenue per Visitor based on a data collected by a restaurant chain. While all the measures work fin...
Need Help
  • JFV's avatar
    JFV
    7 years ago

    Sorry for the late reply. 

     

    The avarages are still not working, but your simplified model made me realized why. I have not checked whether IDReceipt are doubled across restaurants. Since they are, Power BI achieves a different sum of DistinctCount(IdReceipt) if it calculates this value across all restaurants at once than when it would just add Distinct ID Receipts from A, B and C individually. 

     

    So thanks, I understand the problem now and have to sort it out with the client. Solution accepted. 

     

    Regards,

     

    JFW

     

     

v-xicai's avatar
v-xicai
Icon for Community Support rankCommunity Support
7 years ago

Hi  JFV ,

 

Does that make sense? If so, kindly mark my answer as a solution to help others having the similar issue and close the case.

 

Best regards

Amy Cai

JFV's avatar
JFV
Frequent Visitor
7 years ago

Sorry for the late reply. 

 

The avarages are still not working, but your simplified model made me realized why. I have not checked whether IDReceipt are doubled across restaurants. Since they are, Power BI achieves a different sum of DistinctCount(IdReceipt) if it calculates this value across all restaurants at once than when it would just add Distinct ID Receipts from A, B and C individually. 

 

So thanks, I understand the problem now and have to sort it out with the client. Solution accepted. 

 

Regards,

 

JFW