Forum Discussion

sanjanarama's avatar
sanjanarama
Resolver 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 ('table'[Search]),COUNTROWS('table')  &  " customer match(es) found.", "No customer match(es) found.")



before any search is performed im displaying below 

 

  • 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." )

     

5 Replies

  • ValtteriN's avatar
    ValtteriN
    Community Champion
    4 years ago

    Hi,

    Try using ISBLANK. So something like this:

    Total Rows = IF(ISFILTERED ('table'[Search]),

    IF(ISBLANK(COUNTROWS('table') ), "No customer match(es) found.",

    COUNTROWS('table')  &  " customer match(es) found.", "No customer match(es) found."))

    I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!

    My LinkedIn: https://www.linkedin.com/in/n%C3%A4ttiahov-00001/

    • sanjanarama's avatar
      sanjanarama
      Resolver I
      4 years ago

      ValtteriN 
      Too many arguments were passed to the IF function. The maximum argument count for the function is 3.

      im getting above error when i use the dax 

      • ValtteriN's avatar
        ValtteriN
        Community Champion
        4 years ago

        sanjanarama  There was a problem with the brackects. Here is the modified verison:

        IF(ISFILTERED ('table'[Search]),

        IF(ISBLANK(COUNTROWS('table') , "No customer match(es) found.",

        COUNTROWS('table') & " customer match(es) found.", "No customer match(es) found.")))
  • sanjanarama's avatar
    sanjanarama
    Resolver 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." )