Hours Spent calculated member with formula based on different projects

Questions & Answers
,
2

Hi @scv

Thanks for posting your question!
You are very close to the solution, just a few adjustments are needed!

See screenshot below : I have selected Project dimension in Rows and I am at the Project level under the Category level.
I created 3 measures :

  1. Project name = [Project].CurrentHierarchyMember.Name
  2. Category Name = When having Project selected under the Category level, it makes Category being the Parent level for the Project, therefor, to retreive the Categogry name, you can use measure [Project].CurrentHierarchyMember.Parent.Name
  3. And for your formula, you may use sample below. In one case statement I am checking for Project name, in the other one I am looking for the Category Name.
CASE
When [Project].CurrentHierarchyMember.Parent.Name = 'Internal' Then [Measures].[Hours spent] * 0
When [Project].CurrentHierarchyMember.Name = 'DEMO Alpha' Then [Measures].[Hours spent] * 2
ELSE [Measures].[Hours spent]
END

2850×1228 309 KB

Best wishes,

Elita from support@eazybi.com