Count the Number of Blank

[ViralPatel212]

Hello world 

I am trying to create a dax that count the number of blanks -  this represent the number of Dealers who have no contributed.

The way i have done it I have create a new table with Unique values from the main table and used that as a column and create a count to count the distint count of values  but where thers is no data add 0.

Cant seem to count the blanks/no data/0.

Here is the sample file:  Sample File 

[Vertig00]

Hello,

Putting a date value(05/04/2024) as a column in the visual is odd and you're probably not following the best practices in Power BI report development.. Nevertheless, if we accept you scenario as legit - you have to filter on column [05/04/2024] which is done in the following way:

count = 

CALCULATE(COUNT('Sheet1 (2)'[Counter Party])

                   ,'Sheet1 (2)'[05/04/2024] = 0
)

Do not use DISTINCTCOUNT in this case because it will result in a count of 1 (only 1 distinct value on the filtered column equals 0). Also, if [05/04/2024] is an actual date column(as it should be), reference the name of that column instead(i.e. [Date] instead of [05/04/2024]) in the formula above.

Pls let me know if that works. 

[ViralPatel212]

Hello @Vertig00 

that would not seem to work for my case. The reason i have got a date in the column (at the moment its showing 1 day) becuase I am understanding daily which dealer has contributed files.

I used DistinctCount because there are some dealers who send 2 files in a day. 

Main outcome is to

1) identify the number of Dealer contributing

2) Identify the number of Dealer who have not contributing on that day 

Here is the sample file:  Sample File 

[Khushidesai0109]

Hiiii @ViralPatel212 

this Dax measure will help you

CountOfBlanks =
CALCULATE(
COUNTROWS(MainTable),
ISBLANK(MainTable[ContributionColumn])
)


If it did help you please give thumbs up and accept it as a solution.

[ViralPatel212]

@Khushidesai0109 

This did not work for me - jus showed blank values.

Here is the sample file:  Sample File 

[Khushidesai0109]

Hiii @ViralPatel212 
Can you explain to me what you want now? 

[ViralPatel212]

hii @Khushidesai0109 

Main outcome is to

1) identify the number of Dealer contributing

2) Identify the number of Dealer who have not contributing on that day 

Here is the sample file:  Sample File 

As you can see i need to create a new measure to count the 0