Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Total average per category

Hi,   I am currently trying to calculate the total average for a category over a period.   I want the data/table looking like this:   Supplier/Period         17/18                    18/19     ...
  • Anonymous's avatar
    Anonymous
    5 years ago

    amitchandak 

     

    Hmm... all of the values of the measure are exceptionally higher than the actual values? Shouldn't I be using Average or AverageX or something?

Anonymous's avatar
Anonymous
Not applicable
5 years ago

amitchandak 

 

Hmm... all of the values of the measure are exceptionally higher than the actual values? Shouldn't I be using Average or AverageX or something?

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

Anonymous , Try

Avg = calculate(AverageX(Table,[ACTUAL]), allexcept(Table, Table[Supplier]))

 

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.