Forum Discussion
Solved
% of Role Utilisation per project
Hi All need some help. maybe i am looking into it too much but been struggling to come up with a calculation correctly below is sample data, my main data source has approx 15 different column...
Hi Batman_powerbi -can you please create below measures:
DistinctProjectsPerRole = DISTINCTCOUNT(prodj[PROJECT])Total number of projects:TotalProjects = CALCULATE(DISTINCTCOUNT(prodj[PROJECT]), ALL(prodj))%allocation measure as below:PercentAllocation = DIVIDE([DistinctProjectsPerRole], [TotalProjects])Hope this helps. Please check.
rajendraongole1
Super User
Super UserHi Batman_powerbi -can you please create below measures:
DistinctProjectsPerRole = DISTINCTCOUNT(prodj[PROJECT])
Total number of projects:
TotalProjects = CALCULATE(DISTINCTCOUNT(prodj[PROJECT]), ALL(prodj))
%allocation measure as below:
PercentAllocation = DIVIDE([DistinctProjectsPerRole], [TotalProjects])
Hope this helps. Please check.
rajendraongole1
thankyou
i tried using variables to simplify the amount of measures to create
when i do this i am getting a rounded up number rather than a true %, not sure what i am doing wrong
Measure 2 =
VAR A = DISTINCTCOUNT('Data'[Project Name])
VAR B = CALCULATE(DISTINCTCOUNT('Data'[Project Name]), ALL('Data'))
RETURN
DIVIDE(A,B)