DAX to count rows over a partition and filter by total

[databot_kd]

Hi community, 

hoping for some assistance please.. 

I am trying to count total rows over a column where the total of a measure is not 0 or not blank. 

I have tried various count functions but i cant get the count to sum. 

Thanks in advance.

[Ahmedx · Accepted solution]

pls try this

count rows over a partition.pbix