Forum Discussion
Average is not calculated correctly Need Help
Hello I need your help again,
here is the measure for it.
Unfortunately, he does not calculate it correctly.
As you can see, the filter is set to 6 months.
Thus, the sold items should be calculated by the number of months.
As an example:
600PCS/ 6 ( months) = 100PCS
5 Replies
- lbendlin
Super User
Please provide sanitized sample data that fully covers your issue.
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Please show the expected outcome based on the sample data you provided.
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523lbendlin as requested the test file with the same problem
https://we.tl/t-QXVLdlIibV- lbendlin
Ø / Monat = var a = SUMMARIZE('Tabelle1 (2)','Tabelle1 (2)'[Art Nr],'Tabelle1 (2)'[Sale Date].[Month],"s",sum('Tabelle1 (2)'[Quantity])) return AVERAGEX(a,[s])
lbendlin
Thanks for your effort but unfortunately this is not what I need.I am already a small step further and know why PB calculates this incorrectly.
Pictures say more than 1000 words
01.05.2022
01.06.2022
01.07.2022
01.08.2022
01.09.2022
01.07.2022
123
50
70
80
45
74
60
63,2
654
60
60,0
654
0
0
60
0
0
0
10,0
Empty cells are ignored in both Excel and PB.
Now the question arises can I get around this?
Or would it be feasible if I set the date filter to 6 months that I then get the number 6 as a value.
Look at the here please.
- lbendlin
To report on things that aren't there you need to use cross joins and/or disconnected tables.
