Forum Discussion
Average for DAX Column Incorrect
Hi, I'm trying to re-create the measure below but in DAX formula so the averge is correct. This is my measure formula: _Average Corrected = CALCULATE( AVERAGEX( SUMMARIZE( '...
Hi rogerthat ,
Sorry, I can't reproduce your scene, in the data I created, [__Avg/Wk Average/Week Normalized] and [_Average Corrected] appear the same value, there are no two inconsistencies.
Can you show a sample of [_Avg/Wk Average Days/Week] or share a sample pbix after removing sensitive data, we can help you better.
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.