How to calculate count for different date values?

[bourne2000]

Hi

I am having below table

I want to calculate the count of "Yes" for each date as well as total counts for each date and do the ratio. I need to have below table

My date has more than 2000 records with 200 different dates.  I am not sure how to do this DAX calculation? Can anyone advise this?

[nvprasad · Accepted solution]

HI,

CountofYES = calculate(counta(table[datecolumn]),table[category]="YES")
Countofall = counta(table[datecolumn])

Ratio = divide(Count_of_YES,Count_of_all,0)

Appreciate a Kudos! 🙂
If this helps and resolves the issue, please mark it as a Solution! 🙂

Regards,
N V Durga Prasad