Forum Discussion

kumar_din12's avatar
kumar_din12
Frequent Visitor
8 years ago
Solved

how to filter use count function blank values in power bi desktop

hello sir 

by using the only count function.
my my requirement is :- like ind = 3 & uk = 1

 

 

Please find the below attatchnment sirthanks and regards

P.dinesh kumar

  • luxpbi's avatar
    luxpbi
    8 years ago

    This is the formula:

    Count blanks = 
    COUNTBLANK( Table1[value] )

    And this is the output:

    If this is what you are looking for, please mark the answer as accepted.

     

    Regards.

5 Replies

  • Hi kumar_din12,

     

    I don't really understand what do you want to do. 

     

    Do you want to count the number of blank values?

     

    If so, you can do it with 

    COUNTBLANK()

     

    Regards,

     

    • kumar_din12's avatar
      kumar_din12
      Frequent Visitor

      hello sir

       

      Sorry for the trubble to you

       

      vendervaluecountry
      b110ind
      c ind
      d105ind
      e ind
      f130ind
      g135ind
      h140ind
      i ind
      j200uk
      k250uk
      l210uk
      m uk
      n uk
      o310uk
      p410uk

       

      By using the count function 

       

      my requirement is filter the blank values Like 

      Ind = 3

      uk =2

      this is my out put sir

       

      • luxpbi's avatar
        luxpbi
        Icon for Helper V rankHelper V

        This is the formula:

        Count blanks = 
        COUNTBLANK( Table1[value] )

        And this is the output:

        If this is what you are looking for, please mark the answer as accepted.

         

        Regards.