Forum Discussion

Dennis_Pedersen's avatar
Dennis_Pedersen
Helper I
7 years ago
Solved

Average for some rows

Hi    Could you please help with a Dax Formula for calculating average production days? In this case, I need the result 90 for vendor 7 and 70 for vendor 5. (2 orders each vendor). Number of lines...
  • Anonymous's avatar
    Anonymous
    7 years ago
    [Avg Prod Days] :=
AVERAGEX(
	VALUES( Orders[Vendor Number] ),
	[Avg Prod Days for Vendor]
)
-- This works OK even if one vender is visible.

    Best

    Darek

Dennis_Pedersen's avatar
Dennis_Pedersen
Helper I
7 years ago

Hi Darlove

 

Thanks a lot. That works just fine.

That gives the correct figure for each vendor. Is there any way to calculate the correct average for alle vendors ?

Anonymous's avatar
Anonymous
Not applicable
7 years ago
[Avg Prod Days] :=
AVERAGEX(
	VALUES( Orders[Vendor Number] ),
	[Avg Prod Days for Vendor]
)
-- This works OK even if one vender is visible.

Best

Darek