Forum Discussion
A filter challenge...
You need to write a Measure like these one here
ListSizeMeasure := CALCULATE ( SUM ( LIST_SIZE[PRACTICE_LIST_SIZE] ), ALL ( sales ) )
The other problem you still need to resolve are your relationships. Try to achieve a 1:* Relationship - I can't help you here because I don't know your data.
Here you have a working example file. As you can see I'm filtering with the Geograpthy table and the sales part is not intervening.
If this post was helpful please kudo it and mark it as the solution.
Have a nice day Lewdow!
BR,
Josef
Hi v-frfei-msft , thanks - a sample file can be found here - any bright ideas would be appreciated! Thanks.
You need to write a Measure like these one here
ListSizeMeasure := CALCULATE ( SUM ( LIST_SIZE[PRACTICE_LIST_SIZE] ), ALL ( sales ) )
The other problem you still need to resolve are your relationships. Try to achieve a 1:* Relationship - I can't help you here because I don't know your data.
Here you have a working example file. As you can see I'm filtering with the Geograpthy table and the sales part is not intervening.
If this post was helpful please kudo it and mark it as the solution.
Have a nice day Lewdow!
BR,
Josef