Forum Discussion
Solved
problem with a calculation
Hello, Who can help me out, I'm new at Power BI? I have a sales table Let’s say that we sell 3 products (A, B, C). Every day 1 manager is in charge. My table looks like this: Sal...
Hello,
That's not exactly what I'm looking for.
Lets take a look at Manager 1 as an example.The Total Sales Amount for 02/01/2022 is € 214.
The Total Sales Amount for 04/01/2022 is € 240.
What I need, is the average per day and per Manager.
So for Manager 1, for January, this average is € 227 per day.If I try your solution, I get € 75,67 (the average of all the items):
visual
You see my problem?
Thanks.
Try Below Measure
Average Sales = DIVIDE(SUM('Table'[Sales Amount]),DISTINCTCOUNT('Table'[Date]),0)
If this post helps, then please consider Accept it as the solution, Appreciate your Kudos!!
