Forum Discussion

AndyDDC's avatar
AndyDDC
Icon for Most Valuable Professional rankMost Valuable Professional
3 years ago
Solved

Calculate the Average using a Dimension column

Hi, I'm trying to calculate the Average of a dimension attribute based on a Fact table. The following are the tables (simplified, eg Category doesn't actually live in the Fact table but there to vis...
  • tamerj1's avatar
    tamerj1
    3 years ago

    Hi AndyDDC 
    Please use

    AverageMeasure =
AVERAGEX ( Fact, RELATED ( Dim[AnswerID] ) )
tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
3 years ago

Hi AndyDDC 
Please use

AverageMeasure =
AVERAGEX ( Fact, RELATED ( Dim[AnswerID] ) )
AndyDDC's avatar
AndyDDC
Icon for Most Valuable Professional rankMost Valuable Professional
3 years ago

Brilliant, thank you!