Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Recreating FIXED calculation from Tableau

Hello,   I'm trying to recreate a calculation from Tableau that was giving the average Orders per User: { FIXED [UserID] : COUNTD([Order])}   I looked for possible syntax for Power BI, but have ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
3 years ago

It is spread on multiple orders (2-7, many sometimes), so the total count of orders is not important, but how many orders average a user has is what I seek. Thanks

johnt75's avatar
johnt75
Icon for Super User rankSuper User
3 years ago

Try

Avg orders per customer =
AVERAGEX ( VALUES ( 'Users'[User ID] ), CALCULATE ( COUNTROWS ( 'Orders' ) ) )
  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    this solution doesn't make distinct count 😕