Count number of lines, by excluding records with zero value

[Anonymous]

Dear All,

I am importing a small Excel file into a Power BI report. 

In a table I want to show the total number of records, where I don't want to take the record into account with a zero value. 

Simplified the following situation:

Excel file imported:

Line	Number
1	3
2	0
3	8

Desired output in Power BI table:

Number of records

2

When I use the regular conditions (selecting 'Count' in the tabel format, I will receive an output of number of records of 3 (counting the records). 

Any suggestion?

Kind regards,
Reinier

[rocky09 · Accepted solution]

Try this one

count = CALCULATE(COUNT('table'[Number]),'table'[Number] <> 0)