blank count

[Anonymous]

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?

[az38 · Accepted solution]

@Anonymous 

try measure like

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

[amitchandak · Accepted solution]

@Anonymous , Try

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

[az38 · Accepted solution]

@Anonymous 

try measure like

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

[Anonymous]

im trying this is it fine?

COUNTBLANK(Table[Seats])

[az38]

@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.

[Anonymous]

thank you.