Forum Discussion

CookieMonster's avatar
CookieMonster
Icon for Helper I rankHelper I
8 years ago
Solved

Do not show data in Table and Multi-Row Card when Text Filter is empty

I have a Text Filter, a table and a Multi-row Card.   When I search in the Text Filter, only the relevent data is shown in the table and Multi-row Card, but when I clear the Text Filter, all data i...
  • sokg's avatar
    sokg
    8 years ago

    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???

CookieMonster's avatar
CookieMonster
Icon for Helper I rankHelper I
8 years ago

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's avatar
CookieMonster
Icon for Helper I rankHelper I
8 years ago

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?