Forum Discussion

dieterbe_vdb's avatar
dieterbe_vdb
Frequent Visitor
2 years ago

Filter issuev - Context transition

Hello, I have an issue with a measure not behaving as I would expect.   Fact Table: Date MRR Activated Deactivated 1/01/2023 45 1 0 1/02/2023 36 0 1 1/03/2023 75 1 0 ...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
2 years ago

dieterbe_vdb ,

AVERAGEX(VALUES('Date'[YYYY-MM]), [New MRR]) will sum up to the month level, and after that, it will calculate the average. It seems to be working correctly to me.

AVERAGEX(VALUES('Date'[Date]), [New MRR]) sums up to the date level and then calculates the average. Check the file; it is showing the same as the month because you only have data for three dates.