how to add an attribute as Values in a matrix?

[Anonymous]

I have a hierarchy which is a bit mixed, using columns from different Dimensions. The hierarchy is:

Name

Parent

Client Sold

Client Pay

Contract.

I am displaying them in a matrix visual.

As 'values' I have some measures from the Fact table. Now, I have as a requirement to show the ‘address’ of the 'Client Pay' as ‘Values’  too

As expected, the problem is that the data only makes sense if I drill down to the ‘client pay’ level… otherwise when aggregated of course it just picks the ‘first address’ and makes no sense.

Is there a way to show blank, until the user drills down at the ‘client pay’ level?

(I am consuming  a lot of data, so I was looking for an optimal way of achieving this…)

[PaulDBrown · Accepted solution]

Try this measure:

Address = IF(ISINSCOPE (Table[Client Pay]), MAX(Table[Address])

[Anonymous]

Would the formula SELECTEDVALUE be sufficient?