Get sum of column and percentage of it

calculatedmembers
#1

I need to get the total of a single column (in my case, Hours Spent) and get to know the percentage of the different users that have logged hours.

To ilustrate it, look at this example:

Worker 1 has logged 10 hours, so it’s 10% of the total Hours spent
Worker 2 has logged 20 hours, so it’s 20% of the total Hours spent
Worker 3 has logged 70 hours, so it’s 70% of the total Hours spent

#2

You can use a division of hours spent of selected user to any user addressing any user as Logged by default member in a tuple with measure hours spent:

CASE WHEN [Measures].[Hours spent] > 0
THEN
[Measures].[Hours spent]
/
([Measures].[Hours spent],
[Logged by].DefaultMember)
END

image

Daina / support@eazybi.com