

2. Re: Average of Measures
Ken Flerlage Aug 1, 2018 7:32 PM (in response to ljubomir stajic)I think this should be possible. I took each of your measures and turned them into actual calculated fields. I don't know what to call them, so I just called them C1, C2, C3, C4, and C5. I then created an Avg calculated field which does this:
([C1]+[C2]+[C3]+[C4]+[C5])/5
Then I added that measure to the view.
Is this what you're looking for? If so, I've attached a workbook.

Projections2018.twbx 33.9 MB


3. Re: Average of Measures
Tushar More Aug 1, 2018 10:16 PM (in response to ljubomir stajic)Hi,
Hope I understood your requirement correctly. I have not downloaded your as it is quite heavy. But, here an idea using the superstore data set.
Create a calculated field that gives avg of these measure.
Use this field along with your actual measure and also create dual axis to combine them,
Hope that helps.
~Tushar

4. Re: Average of Measures
ljubomir stajic Aug 2, 2018 9:45 AM (in response to Ken Flerlage)Hi Ken,
The problem with your formula is that it breaks when one of the measures is null (data filtered out). The formula has to be a little more dynamic than that.
Thanks so much.

5. Re: Average of Measures
ljubomir stajic Aug 2, 2018 9:55 AM (in response to Tushar More)Hi Tushar,
I'm not sure you got the issuethe formula you posted is an average sum for each region by year. In other words, you only have 1 measurethe Sales.
I'm trying to find an average of multiple measures.
Using your example, the formula would look something like the one copied below. Unfortunately, my attempt contains an error. Perhaps you can help fix it.
My main concern is that sometimes one of the measures can disappearThe formula for Average has to be dynamic enough to take this into account.
Thanks so much.