Hi,
I want to show a member count based on state level, which means it should be changed by [State] variable only. The LOD calculation I write is :
"SUM({Fixed [state]: countd(member)})"
I have another LOD calculation which is based on national level:
"SUM({Fixed: countd(member)})"
These two calculation return the same result when there is no other filter applied and all states are selected.
However, if I apply "Provider" filter by selecting any specific providers, like "provider A", the result based on state level changes dramatically (e.g. from 2,000,000 to 32,000), but the result based on national level keeps fixed (e.g. 2,000,000).
Can anyone tell me why this is happening?
Thanks!
hi Fangyuan,
Good question! So the first LoD is computing the countd of members for each state, and is attaching the result to each state. This means when you filter to "provider A", and say Provider A is only in 4 states that LoD is now just the addition to those 4 states.
The second version is doing a countd over the entire dataset and attaching the result to every row, so as long as you have 1+ rows unfiltered out it will return the countd for the whole dataset.
Does that make sense?
