Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Dear Community,
I am completly confused.
I like to get the average of a week, but my total average is not correct see at the example:
If I calculate it: (7.2+66.9+62.9+45)/4= 45.5
What am i doing wrong? 😕
Thank you for you help
Solved! Go to Solution.
hi @Anonymous
This looks like a measure totals problem. Very common. See this post about it
https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dealing-with-Measure-Totals/td-p/63376
Also, this Quick Measure, Measure Totals, The Final Word should get you what you need:
https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/m-p/547907
For your case, just use AVERAGEX instead of SUMX like above in the measure like this
New measure =
VAR __table = FILTER(SUMMARIZE('Table1',[Anlage],[Datum]"__value",[zel]),[__value]<>0)
RETURN
IF(HASONEVALUE(Table1[Name]),[m_Single],AVERAGEX (__table,[__value]))
If you still have problem, please share your sample pbix file for us have a test.
Regards,
Lin
hi @Anonymous
This looks like a measure totals problem. Very common. See this post about it
https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dealing-with-Measure-Totals/td-p/63376
Also, this Quick Measure, Measure Totals, The Final Word should get you what you need:
https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/m-p/547907
For your case, just use AVERAGEX instead of SUMX like above in the measure like this
New measure =
VAR __table = FILTER(SUMMARIZE('Table1',[Anlage],[Datum]"__value",[zel]),[__value]<>0)
RETURN
IF(HASONEVALUE(Table1[Name]),[m_Single],AVERAGEX (__table,[__value]))
If you still have problem, please share your sample pbix file for us have a test.
Regards,
Lin
ZLE is a measure. And I would like the average per Week of the ZLE without zeros
The calculation looks like that:
@Anonymous
If you are satisfied with my answer, please mark it as a solution so others can easily find it.
Don't forget to give KUDOS ? to replies that help answer your questions
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
@Anonymous , seems like you need simple averages , try like
averageX(summarize(Table, Table[anlage],table[datum],"_1",[zie]),[_1])
User | Count |
---|---|
87 | |
72 | |
69 | |
64 | |
56 |
User | Count |
---|---|
99 | |
91 | |
80 | |
74 | |
64 |