Forum Discussion
Using Slicer as AND Filter
Hi Anonymous
Just got you, kindly add another measure:
Measure 2 = CALCULATE(COUNTROWS(FILTER(VALUES(AnswerFeatures[UserID]),[Measure]="1")))Put it into the card.
Hi v-diye-msft
I still see same problem. I have downloaded it in there : https://www.microsoft.com/en-US/download/details.aspx?id=56723
Best,
Hi Anonymous
Let me explain the details:
Please add the measure:
Measure = var t = CALCULATETABLE(VALUES(AnswerFeatures[SurveyID]),ALL(AnswerFeatures[SurveyID]))
var a = ALLSELECTED(AnswerFeatures[SurveyID])
Return
IF (
ISBLANK ( COUNTROWS ( EXCEPT ( a, t ) ) ),
"Yes")It will filter the "AND" results from the selection of slicer.
There 2 tables connected by response ID. note that you can't use the SurveyId in ResponseFeature to filter the userID in AnswerFeature.
Hi v-diye-msft
It seems good but I want to try to see count of userID which submit selected all surveys in Card Visualization, it is not working. Because I can not filter Measure = Yes
Hi Anonymous
You can filter the measure is not blank, or change the below as "1", then filter it =1 :
Measure = var t = CALCULATETABLE(VALUES(AnswerFeatures[SurveyID]),ALL(AnswerFeatures[SurveyID])) var a = ALLSELECTED(AnswerFeatures[SurveyID]) Return IF ( ISBLANK ( COUNTROWS ( EXCEPT ( a, t ) ) ), "1")Hi v-diye-msft
I can not filter the card visulation by Measure. It doesnt let me to the change filter as you said.