DAX measure - average of objects per month

[Youri98]

Hi!

I'm trying to count objects and average it out per month. The problem I have is that some objects are active from a different month (for example April). When I filter for example January - May. The objects that get added in April get a 0,4 value instead of 1. The monthly totals are correct. But when I try to get the average, it doesn't use the Monthly totals, but it works with the fractions of 0,2 and 0,4 etc.

Total

138

138

138

198

198

156,4

As you can see the totals are 138, 138, 138, 198, 198. The average would be 162. But the average I'm getting is 156,40 (because of the 0,2 and 0,4 etc). I see why it does this. But how would I fix this?

A row that's active since January:

VUR952000144

1

1

1

1

1

1

A row that's active since April:

VUR952000145

1

1

0,4

Thanks in advance!

[lbendlin · Accepted solution]

You use aggregators like AVERAGEX in such scenarios.

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information. Do not include anything that is unrelated to the issue or question.
Please show the expected outcome based on the sample data you provided.

Need help uploading data? https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...

[Youri98]

I somehow got it to work. Thanks!