Forum Discussion
Dynamically Ignore Slicer Interaction
I have pretty standard star schema relationship. FactSales Table DateKey EmpId ClientId SaleTypeId GBPValue Dim Date Table, Date Key Year Month etc.. Dim Employee Table EmpId Gr...
RobbLewz , Not very clear. But in such cases have independent tables and use slicer value as per need
example
measure =
var _tab = allselected('Date'[date])
var _cli = allselected('Clinet'[Id])
return
calculate(countrows(FactSales ), filter(FactSales, FactSales[clinetID] in _cli && FactSales[Date] in _tab))
You can use some other filter not to pass a filter