Forum Discussion

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
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

JFV

Frequent Visitor

7 years ago

Thanks for the reply!

However, I could not use this solution as I do need to take full Revenue into account, not just P&M (P&M is just a abbreviation for main courses - we only count visitors as those who order it, but in calculating avarage revenue per X we still use all orders). Regardless, I did enter revenue formula as you suggested to check if it works, and sadly it did not help - the total sum still seemed unrelated to the avarages of singular restaurants.

Plus, in Your file if you change the formula of Revenue so it is just sum of Net Value, and swith off the "P&M" filter the total sum is still correct. Can the problem lay elsewhere?

Regards,

JFV