IF condition is not working with Hierarchy

[Anonymous]

Hi Everyone,

As per my requirement, I need to count the login count for each user and reprsent week start date.

To do that I have created a new date columns "Month& Year" and "Week Start Date" & using two columns as hierarchy in matrix.

If user don't have login count on eny week it should represent with "0" instead of blank. It is working with one level hierarchy, but not when I drill down to second level. (or) working when I selected one user , not working when I selected two user.

Activity Count =

var  acv = CALCULATE(COUNT(SavedSearch'[Activity]), SavedSearch'[Activity] = "ViewReport")

return

IF(acv<>BLANK(),acv,0)

Two users

[amitchandak]

@Anonymous , Simply Try +0

CALCULATE(COUNT(SavedSearch'[Activity]), SavedSearch'[Activity] = "ViewReport") +0

[Anonymous]

Thank you so much for your resonse Amit. I tried with the aproach what you have suggested, but its not working.

Can you please suggest other solutions?