Forum Discussion
Problem with total percentages
Hi experts, I am trying to get from all the users, the percentage of Males and Females, ignoring the blank() values: Pc M_F =
DIVIDE (
[Number of users no blank];
...
Thanks parry2k for your response. Yes, it is a little bit different from original post, but instead of "Male" and "Female" are ages. It should be the same measure but taking in count another columns, but the idea behind is the same.
parry2k
Super User
Super UserAnonymous but you are not following the same method for Denominator'
This is what the oirignal measure was for Denominator in DIVIDE function.
Total Number of Users = CALCULATE( [Number of uses not blank], ALL( 'Table'[Gender Label] ) )