Forum Discussion
Measure not ignoring filters?
Anonymous
you find min and max dates from date table with variables.
then you used it for filter fact table. what context do you want to use further?
could you give an example: data sample and desired output based on this sample?
So my Date table is connected to a FiscalTransaction table by date. The Fiscal Transaction table is connected to an order table by ID (Both filter directions). The order table is finally connected to my Retail table by ID (One to One so both filter directions is on).
I want my measure to pretty much ignore that whole chain above. I have filter selections on my page from the Date table as there are other measures that it works with.
I need to use the filter selections on the page to determine my min and max dates. Then filter my retail table by those min and max dates, but ignore the relationship chain described above.
I can tell what's happening in my measure. There are a number of ID's in my Retail table that are not in the Order table. So I think the measure is taking the dates from my date table based on the slicers on my page, then filtering the Fiscal Transaction table by those dates. Then the Fiscal Transaction table has a set of ID's which it is then filtering the Order table by ID. Then the Order ID table is filtering my Retail table by those same ID's resulting in a much lower number. I want my measure to ignore the whole chain I just described as there are a number of ID's that are present in the Retail table that are not on the Order table.
I can verify this is the case because if I remove all the slicers on the page from my Date table and manually filter my Retail table by the min and max dates, I get the correct number. As soon as I put a slicer on my page from the Date table, the number goes way down. So the slicer from the Date table is having an impact on my measure when I don't want it to.