Need help with blanks calculation measure in matrix table
Hi all, I am using these measures below:
ams measure = vara = DISTINCTCOUNT(AM[Exec_name])
wins measure AM table = vara = COUNT(AM[WIGS_Wins_Achieved])
percentage am table = vara = DIVIDE(AM[wins measure AM table],SUM(AM[WIGS_Target]),0) * 100
It is not calculating blanks at all. Below i am attaching a picture for the reference that the measures are not working properly. Is there a workaround for these measures? I want to show blank as 0 in my matrix table. Thanks in Advance.