Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Aggregating a calculated measure

I have data (columns) containing yearly data points to calculate gold production

i then have a calculated measure called gold production which uses the columns and parameters (to perform sensitivity analysis)

I also have another calculated measure, called AISC, which uses the gold production calculated measure as well as other calculated measures.

 

i cannot aggregate AISC to a yearly average on the Card Visualization.

 

Where am going wrong? am i using the wrong visualization?

 

XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX

Need Help

6 Replies

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

    Anonymous , Not very clear , a measure like this

    averageX(values(Table[Year]), calculate(Sum(Table[AISC])))

     

    or with date table 

    averageX(values(Date[Year]), calculate(Sum(Table[AISC])))

     

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

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Hi Amit - thank you. I'm new to this community so I do not see how i can attach the pbix file to this message. How do you do that? There is no sensitive data so i can easily share the whole file with you.