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
not sure exactly what was happening with the rounded numbers, but started fresh and all works as intended
thankyou for the help