Hard to answer without seeing your data. Any chance you can share a packaged workbook?
sorry for the late response!
Unfortunately I cannot post any data due to corporate restrictions.
But I can explain it to you in a little bit more depth:
In general I have the measure "Sales". I filtered this measure by the company ID (every company has one). Now I want to compare this result with all companys, thus removing the global filter on company ID for this. Caused by the fact that Sales in my dataset is a table calc, I cannot use EXCLUDE LOD Function.
Is there another way to get to the solution here?