Forum Discussion
Filtering from Many side to One without Cross Filtering
Hi Anonymous ,
As long as the "Abuse/Not" column is added to the table visual or there is an "Abuse/Not" column in the filter context of the matrix formula, the slicer can affect the table visual.
Or is this what you want?
So I feel very strange about your statement, please provide a sample .pbix file.
Best regards,
Lionel ChenIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I created this measure and put in the visual level filter of the table and restricted as not blank
Count of Abuse =
Var Abuseas1 = CALCULATE(COUNT(Lead_ID[Abuse/Not]),FILTER(Lead_ID,Lead_ID[Abuse/Not]=1),CROSSFILTER(EMails[Email],Lead_ID[Email ],Both))
Var Abuseas0 = CALCULATE(COUNT(Lead_ID[Abuse/Not]),FILTER(Lead_ID,Lead_ID[Abuse/Not]=0),CROSSFILTER(EMails[Email],Lead_ID[Email ],Both))
Var Abuseas00r1 = CALCULATE(COUNT(Lead_ID[Abuse/Not]),CROSSFILTER(EMails[Email],Lead_ID[Email ],Both))
Var Abuseasblank = CALCULATE(COUNT(Lead_ID[Abuse/Not]),FILTER(Lead_ID,Lead_ID[Abuse/Not]=BLANK()),CROSSFILTER(EMails[Email],Lead_ID[Email ],Both))
Return
SWITCH(TRUE(),SELECTEDVALUE(Lead_ID[Abuse/Not])=1,Abuseas1,SELECTEDVALUE(Lead_ID[Abuse/Not])=0,Abuseas0,SELECTEDVALUE(Lead_ID[Abuse/Not])=BLANK(),Abuseasblank,Abuseas00r1)
I am getting values when i am selecting the slicer as 1 or 0
but when i am selecting blank(), i am getting empty table
is there anything wrong in my measure??
Hi Anonymous ,
As long as the "Abuse/Not" column is added to the table visual or there is an "Abuse/Not" column in the filter context of the matrix formula, the slicer can affect the table visual.
Or is this what you want?
So I feel very strange about your statement, please provide a sample .pbix file.
Best regards,
Lionel Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.