How to show records which has 0 value in a field?

[BBIUser]

Hi,

In SQL, if you want to show the records which has 0 values, we apply where clause and get the records only applied to this where clause.

and Enrol_count = 0

Similar way,

I want to show the count of records from a field for just 0 values(has 30 records in it).

I am planning to use 'Card' visualization for this, to show the count of rows.

How to do this in Power BI?

Much appreciated. Thanks!

[Greg_Deckler]

So, no sample data provided but I will take a wild guess:

Measure = COUNTROWS(FILTER('Table'),[Column]=0))

[BBIUser]

Thanks @Greg_Deckler. This is exactly what I wanted to use. 

What if I want to use another field in the same DAX? Here is what I tried doing but has an error.

ChoiceEnrol2 = COUNTROWS(FILTER(ZeroTFSlLevel, ZeroTFSLevel[PlaceOrPte] = "Pte"), FILTER(ZeroTFSlLevel, ZeroTFSlLevel[Enrol_count] = 0))

[v-yuezhe-msft · Accepted solution]

@BBIUser,

Please check if the following DAX returns your expected result.  If not, please share sample data of your table and post your desired result.

Measure = COUNTROWS(FILTER(ZeroTFSlLevel,ZeroTFSLevel[PlaceOrPte]="Pte"&&ZeroTFSlLevel[Enrol_count] = 0))

Regards,
Lydia

[BBIUser]

Works Perfectly @v-yuezhe-msft Lydia. Much appreciate your response!