Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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!
Solved! Go to Solution.
Hi,
Maybe this is the measure.
Measure =
COUNT ( Table45[Fruit] )
/ CALCULATE ( COUNT ( Table45[Fruit] ), ALLEXCEPT ( Table45, Table45[Quarter] ) )
Best Regards!
Dale
Hi,
Maybe this is the measure.
Measure =
COUNT ( Table45[Fruit] )
/ CALCULATE ( COUNT ( Table45[Fruit] ), ALLEXCEPT ( Table45, Table45[Quarter] ) )
Best Regards!
Dale
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
User | Count |
---|---|
128 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |