Forum Discussion

sanjanarama's avatar
sanjanarama
Icon for Resolver I rankResolver I
4 years ago
Solved

countrow when return zero or blank

I have a filter and want to display count of rows returned after search. but im not able to figure out how to write condition if blank is returned from count rows  Total Rows = IF(ISFILTERED ('tab...
  • sanjanarama's avatar
    sanjanarama
    4 years ago
    In case if anyone is looking for solution, i did figure out


    1) first create measure to get total rows and return 0 if no rows
    TotalRowsCount = IF (CALCULATE ( COUNTROWS('Table') ) = BLANK (),
    0,
    CALCULATE ( COUNTROWS('Table') )
    )

    2) create below measure to get the display 
    Total Rows =     IF( ISFILTERED ('Table'[Search]) ,'Table'[TotalRowsCount] & " customer match(es) found.", "No customer match(es) found." )

     

sanjanarama's avatar
sanjanarama
Icon for Resolver I rankResolver I
4 years ago
In case if anyone is looking for solution, i did figure out


1) first create measure to get total rows and return 0 if no rows
TotalRowsCount = IF (CALCULATE ( COUNTROWS('Table') ) = BLANK (),
0,
CALCULATE ( COUNTROWS('Table') )
)

2) create below measure to get the display 
Total Rows = IF( ISFILTERED ('Table'[Search]) ,'Table'[TotalRowsCount] & " customer match(es) found.", "No customer match(es) found." )