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
Hello lewdow,
if I understand you right you just need either the function all or allexcept.
The answer to your question lies in this wunderful article from the SQLBI guys. -> https://www.sqlbi.com/articles/managing-all-functions-in-dax-all-allselected-allnoblankrow-allexcept/
I hope the answer is helpful - if not please provide us with some sample data :-)
BR,
Josef