Forum Discussion
Helper IDo not show data in Table and Multi-Row Card when Text Filter is empty
1. Create a measure
MeasureToCheck = COUNTROWS(ALLSELECTED(Sheet1[AnimalType]))
2. Select table visual first and then click and drag that measure to visual level filter (see pic below)
and choose is 1.
3. Repeat 2 but first click row card.
So we have
then
and at the end
Are you ok???
Are you ok with this???
Helper ISorry im new to Power BI, can you expand on what you mean by try SELECTEDVALUE?
And what do you mean by 'measures used in Multi-row Card and which column use in Text Filter', do you mean what fields and filters?
Solution SupplierYou should use SELECTEDVALUE in all those cases when you need to read a single value selected in the filter context, obtaining blank or another default value in all other cases.
More info here
https://www.sqlbi.com/articles/using-the-selectedvalue-function-in-dax/
Yes show fields and filters
- CookieMonster
Text Filter is using the Field: AnimalType
Multi-row Card is has the filter: AnimalType (All)
And when I type in the Text Filter, it does filter the Multi-Row Card as expected, so that works fine, its just getting it to show nothing in Multi-row Card when the Text Filter is blank, im looking into that link now, just seems confusing to me until I learn and understand DAX and how to access it in Power BI
- sokg
Can you provide us with sample data???
- CookieMonster
Unfortuently not, I could put some sample data together in excel as the source and alter my BI report to use that until I work out how to do this?
I have tried creating a new measure, which I set the DAX to 'Measure = SELECTEDVALUE ( T1[AnaimalType] )', and applied it as a filter to the Multi-row Card, but this hasnt achieved what im after, im guessing im using it wrong.