Forum Discussion
Problem with total percentages
Hi parry2k I've tried what you did, but with no success. I did it, with other data. This is what I have:
In this example, for 35-39 it should be 42% and so on. I can not get the "Total" (7), to divide into each "Numb of usersbin"
Numb of usersbin = CALCULATE (
[Users Registered];
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"} )
)
%Usrs AgeBin = DIVIDE( [Numb of usersbin]; [Users Registered])
Anonymous what is the measure for [User Registered] if you are going to check such a big range we could have done it differently. Can you drop it in the table and see what value you are getting?
- parry2k The measure is this:
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/38490Thanks 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.