Forum Discussion
Aggregating a calculated measure
Anonymous , Please check the measure2, I added. But I used your measure to do the Average calculation
The file is attached after signature
Super UserAnonymous , 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.
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.
- amitchandak
Anonymous , You can load to one drive or dropbox and share the link.
Please make sure you share expected output.
You can copy paste data from excel to here: refer my video : https://www.youtube.com/watch?v=1_XlyzV-PcY
Check the heading on progress bar to jump
amitchandak here is the drop box link
https://www.dropbox.com/s/605gqijkn0pbwxy/Detour%20Lake%20Proof%20of%20Concept.pbix?dl=0
you'll see in the 2nd visualization tab called "KPI's" i'm trying to show the yearly average AISC - however $2 is showing up which is clearly wrong.
thank you again.
- amitchandak
Anonymous , Please check the measure2, I added. But I used your measure to do the Average calculation
The file is attached after signature