Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

blank count

Hi all,

 

i want create a kpi object .     count of blank  seats      from the table   SELECT * from Personal.fact_AIS_Specific   ;

 

how can i create a measure?

Need Help
  • az38's avatar
    az38
    6 years ago

    Anonymous 

    try measure like

    CALCULATE(COUNTROWS(Table), ISBLANK(Table[seats]))

     

  • amitchandak's avatar
    amitchandak
    6 years ago

    Anonymous , Try

    calculate(countrows(Personal),isblank(Personal[fact_AIS_Specifi]))

5 Replies

  • az38's avatar
    az38
    Community Champion
    6 years ago

    Anonymous 

    try measure like

    CALCULATE(COUNTROWS(Table), ISBLANK(Table[seats]))

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      im trying this is it fine?

       

       

      COUNTBLANK(Table[Seats])
      • az38's avatar
        az38
        Community Champion
        6 years ago

        Anonymous 

        that's great, I never used this function before 🙂

        but pay attention - 

        If no rows are found that meet the condition, blanks are returned.
  • amitchandak's avatar
    amitchandak
    Super User
    6 years ago

    Anonymous , Try

    calculate(countrows(Personal),isblank(Personal[fact_AIS_Specifi]))