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???
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
Helper IText 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.
- CookieMonster
Im wondering if your understanding my question, SELECTEDVALUE looks to be to put in a default value if a cell is blank, otherwise use the cell value.
But this is not what im after, can you confirm if my orgional question makes sense?