Matrix Question

[yogita]

 Hi All, I have created a matrix which has three fields in rows Phasecode, Phasecode Desc and Emplyee name and then I have revised Est for Each Phasecode. I donot want the value of Revised Est repeated in for Phasecode Desc and Emplyee name. How can I achive the matrix view as shown below in the right.

[GilbertQ]

Hi @yogita 

What happens if you had to change it only looking for where the INSCOPE using an IF statement instead of the switch true?

[yogita]

No Change. 

[GilbertQ]

Hi @yogita 

Off the top of my head you would need to create a DAX measure and use the ISINSCOPE DAX funtion, which you can then look at the scope/level of your hierarchy and then set it to blank on those hierarchy levels.

[yogita]

Hi @GilbertQ 

Yes I am using the below measure. The problem is that it is showing revised est only at the phase code level. I want the value only against the Phasecode when the entire hirerchy is expanded.

Revised Est =

Var _New =CALCULATE(min(ProjectModuleDataView[RevisedEstimate]))

RETURN

Switch(true(),

ISINSCOPE(ProjectModuleDataView[Employee_Name]),"-",

ISINSCOPE(ProjectModuleDataView[PhasecodeDesc]),"-",

ISINSCOPE(ProjectModuleDataView[Phasecode]),_New)

Thanks

[yogita]

@GilbertQ - Can you suggest changes to the measure? Not able to figure out myself.  Thanks