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
johnt75's avatar
johnt75
Super User
3 years ago

Try

Avg orders per customer =
AVERAGEX (
    VALUES ( 'Table'[User ID] ),
    CALCULATE ( DISTINCTCOUNT ( 'Table'[Order] ) )
)

If you know you have only 1 row per order then you could replace the DISTINCTCOUNT with COUNTROWS('Table')

Anonymous's avatar
Anonymous
Not applicable
3 years ago

it calculated for half an hour and gave an error can't show visual