Countifs Functiion (Dynamic by every row)
1. I want to count "every date" by "each country" when "Confirmed column is nonblank or >0". In excel file we can do it by countifs function. What would be the Dax formula for this solution? Date Confirmed Recovered Deaths Day of Year Province Country Corona Days (Expected Result) 22-01-20 5 Bangladesh 1 22-01-20 Sweden 0 22-01-20 US 0 22-01-20 UK 0 22-01-20 417 India 1 22-01-20 694 Italy 1 22-01-20 411 Denmark 1 23-01-20 229 Norway 1 23-01-20 146 UAE 1 23-01-20 265 Bangladesh 2 23-01-20 388 Mali 1 23-01-20 358 Italy 2 24-01-20 599 UK 2 24-01-20 371 Bangladesh 3 24-01-20 776 Sweden 1
