Forum Discussion
Advocate IIIgnore Slicer in measure
mnarmeen For my problem the only thing that works is editing the visual intercations. But in your case, since you are using a date filter, I would recommend a different approach. Always create a date/calendar table and don't link this table to the rest of your data model. Then you can always use this table for your filters and have all the freedom when creating measures, like:
Measure = Calculate( Countrows(Table1), Filter(Table1, Table1[Date] >= MIN(Dateteable[Date]) && Table1[Date] <= MAX(Dateteable[Date]) && other Filter rules.... ) )And if you don't want your date filter to influence your measure, you just leave the first two filter rules out.
Hope this helps. Let me know if I misunderstood the question.
Best,
Sebastian
Advocate IDid you manage to solve it? sguenther , I have the same issue where I have a column in table which have to show overall quantity but the date slicer changes it to the current selection. I want to ignore only one column from filter but it doesnot seems to work. Any idea?
Advocate IImnarmeen For my problem the only thing that works is editing the visual intercations. But in your case, since you are using a date filter, I would recommend a different approach. Always create a date/calendar table and don't link this table to the rest of your data model. Then you can always use this table for your filters and have all the freedom when creating measures, like:
Measure =
Calculate(
Countrows(Table1),
Filter(Table1,
Table1[Date] >= MIN(Dateteable[Date]) &&
Table1[Date] <= MAX(Dateteable[Date]) &&
other Filter rules....
)
)And if you don't want your date filter to influence your measure, you just leave the first two filter rules out.
Hope this helps. Let me know if I misunderstood the question.
Best,
Sebastian
I was stuck for ages with this, I couldnt think a simple trick like this would do it. Thank you so much
- mnarmeen
Thankyou so much. Your recommendation of not linking th date table and using the filter is on point.
I need to make many changes to incorporate this , but you totally nailed it !
Thanks alot, for saving my time and effort !
Hello,
Let's say I can't remove the Filter Table relationship from the Fact Table. I use the Filter Table as a slicer. Is it possible to ignore the slicer for measures that count rows in my Fact Table?
Ideally, I would like to make a selection in the Filter Table, but for the measure in question, count the rows as if the slicer was not selected.
End result, I want to compare a single business unit to total company. I do not want the other business units visible. I expect to filter out the other business units by using the business unit slicer but have a measure that calculates total company.
Thank you!
Anonymousyou would use either the ALL or the ALLEXCEPT formula, depending on the specifics of your case.
Hi,
It is Working for me as well. Thanks for the solution man. I really appreciate your solution here.
:)
Hi SG
Your solution works quite fine for my measures, but now my columns do not respond to the filter anymore since the dates in my table are not linked anymore to the calendar date. How can I fix this?
Best,
Anneke