Forum Discussion
Problem with total percentages
Anonymous try following measures:
Number of uses not blank =
CALCULATE(
SUM( 'Table'[Users] ),
KEEPFILTERS( 'Table'[Gender Label] IN { "Female", "Male" } )
)
Total Number of Users =
CALCULATE( [Number of uses not blank], ALL( 'Table'[Gender Label] ) )
% = DIVIDE( [Number of uses not blank], [Total Number of Users] )
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/38490