Calculate how many people have a past due balance in each column

[aa_lovee]

I am trying to calculate how many people have a past due balance in each column. 

For example:

30 Days Past Due = 39 ppl have a past due balance 

60 Days Past Due = 21 ppl have a past due balance

Attached is a snippet of part of the table to get a better picture of what I am mean. Some people have a balance of $0, and other people have an outstanding balance in each of the columns for days past due. I am just looking to get a count of those with a balance for each column. 

[v-yiruan-msft · Accepted solution]

Hi @aa_lovee ,

I created a sample pbix file(see the attachment), please check if that is what you want. There are two pages in the report and used different methods to achieve it separately, you can find the details in the attachment.

Best Regards

[aa_lovee]

Thank you, I believe I did it a similar way. I just created measures for each of the Days Past Due using the DAX Formula: 

CALCULATE(COUNT('GOVTCC Delinquency Report'[30 Day Past Due]),FILTER('GOVTCC Delinquency Report','GOVTCC Delinquency Report'[30 Day Past Due] > 0))

And just used the Card Visualization to portray the answer i need. Thanks for the help and info!