Forum Discussion
problem with a calculation
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!!
Hi NicoHa ,
1. Select matrix chart.
2. Add manager fields to rows
3. Add month field in Columns.
4. Add sales amount field in values.
5. There is a drop down arrow on sales amount click and select average insted of sum.
If this post helps, then please consider Accept it as the solution, Appreciate your Kudos!!
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.