Table of a Remaining estimated hours by member user with except for one specific user

Questions & Answers
1

Hello friends!

Remy looking for your kind help
I am just trying to make a table of a Remaining estimated hours by member user with except for one specific user.

I have rows Issue (sub-task hierarchy) and Assignee (select user hierarchy level members).
For Mesures dimension, I have a define field RAF(j) = [Measures].[Remaining estimated hours history]/8 and I want a different calcul for specific one user for example
RAF(j)=([Measures].[Original estimated hours]-[Measures].[Hours spent])/8

Could you help me please

Thanks

2

Hello everyone,

Do you have an idea?

Thank you

3

Hi @eremy

You can use the CASE statement in your formula for the RAF(j) measure so that it would look something like this:

CASE WHEN
[Assignee].CurrentHierarchyMember.Name = "David Sand"
THEN
([Measures].[Original estimated hours]-[Measures].[Hours spent])/8
ELSE
[Measures].[Remaining estimated hours history]/8
END

This will use the specific formula in cases when the Assignee’s name in the Rows section matches the name you set and the other formula for all other cases.

Let me know if this fits your use case!
Best regards,
Nauris / eazyBI support