Find no of Zeros in rows with respect to another column(For example emp. code)

[Anonymous]

Dear all,

As i am new to this environmet, i need all your suggestion about following problem.

I have 2 columns called "emp code" and "entry time". In my table  same "emp code" will be in multiple rows with their each day's time entry entered in "entry time" column of multple rows.  Now i need to summerise this like, for one "emp code"  how many "0" entry(count) in ""entry time"  column. And like this for each unique emp id, how many 0 entries exist to be created in separate calculated column.

Please help me in this.

Regards,

Mahesh

[Mariusz]

Hi @Anonymous 

Can you provide a data sample?

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
LinkedIn

[Anonymous]

@Mariusz First one is issue and 2nd is expected result.

And like this, multple ”emp code” will be there in same "emp code” column and for each, i need to get the total count of 0s and to be displayed like 2nd image.

Thanks for your support!

Regards,

Pon maheswaran K

[Mariusz · Accepted solution]

Hi @Anonymous 

Try this

Measure = 
CALCULATE(
    COUNTROWS( 'Table' ),
    'Table'[entry time] = 0
)

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
LinkedIn

[Anonymous]

Dear @Mariusz ,

Thanks for your reply. it is working as expected. Thanks for your timely support.

Regards,

Pon.