Forum Discussion
Problem with total percentages
Users registered = calculate(
DISTINCTCOUNT(UseDevSesDayVid[IdRegistered]);
UseDevSesDayVid[IsRegistered];
UseDevSesDayVid[IsNewIdRegisted];
KEEPFILTERS( DimFan[AgeRange Label] IN {"<10";">=65";"10-14";"15-19";"20-24";"25-29";"30-34";"35-39";"40-44";"45-49";"50-54";"55-59";"60-64"} )
)
Anonymous seems like this requirement is totally different than original post.
You need to explain bit with data sample what you are trying to do. If you look at your original measure, denomitor it is totally different than what you are showing here.
Read this post to get your answer quickly.
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
- Anonymous7 years agoNot applicable
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.
- parry2k7 years agoSuper User
Anonymous 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] ) )