Trend over time expressed as percentage of total volume over time periods

[Tsch]

Greeting all,

I need help through a mental block. I am sure it is a couple of measures that need to be involved here but cannot seem to find the correct path.

I need to create a line chart showing trends over time with values shown as a percentage of total of that time period (quarter, month). Using the % of grand total shows a total of the relevant time period not the percentage of what it was that quarter. The time period total count varies between time periods.

 What are the correct measures to use here? There has to be a count performed since they are individual rows. So the final measure would be something like =COUNT (fruit) / (Quarterly Volume)

Each row is a single occurence in the data. For example:

Region	Quarter	Fruit
1	1	Apples
1	2	Oranges
1	3	Pears
1	4	Grapes
2	1	Apples
2	2	Oranges
2	3	Pears
2	4	Grapes
3	1	Apples
3	2	Oranges
3	3	Pears
3	4	Grapes
4	1	Apples
4	2	Oranges
4	3	Pears
4	4	Grapes

It should appear like this except each point is a % of quarterly total.

Thanks!

[v-jiascu-msft · Accepted solution]

@Tsch

Hi,

Maybe this is the measure.

Measure =

COUNT ( Table45[Fruit] )

/ CALCULATE ( COUNT ( Table45[Fruit] ), ALLEXCEPT ( Table45, Table45[Quarter] ) )

Best Regards!
Dale

[Tsch]

Dale,

You got it! Works as I would expect. Now to go educate myself a bit more on why that allexcept function works...

Thanks!

tsch