Not able to calculate average from distinctcount

[helgekooi]

I'm an absolute beginner, with experience in excel. In powerBI i try to calculate the average instead of subtotals.

I created a calculated field to devide two parameters, that worked:

Bezetting 1,5m = (DIVIDE(   DISTINCTCOUNT('Export_150_cm_gebruik'[PC's actief]),    Calculate(DISTINCTCOUNT('PC''s'[PC's beschikbaar]), 'PC''s'[150cm] IN {"ja"})))

Difficult to explain what i want, but i'll try:

Field 1 contains the pc's in a specific location that are safe to work in Covid-social distancing. Field 2 contains the pc's that were active and stated safe to work on. Field 4 contains pc's that were active but not safe to wordk on. 

The calculated field divides measure 2 by 1, to get the result 3 (I'm kinda proud that that works)

The same happens with field 4 (divided by field 1). The total (field 6) is calculated correctly.

[v-lili6-msft]

hi  @helgekooi 

Do you mean for Field 4, it shoudl divide by 1308?

What is formula of measure [Totaal van PC's actief]?

It should as this:

Totaal van PC's actief = Calculate(DISTINCTCOUNT('PC''s'[PC's beschikbaar]), 'PC''s'[150cm] IN {"ja"}))

If not your case, please share your sample pbix file for us have a test.

Regards,

Lin

[parry2k]

@helgekooi I would recommend to post the raw sample data and expected output rather than image, it will be easier to work with sample data.