how to display attribute of a dimension as a column only on specific level?

[Anonymous]

I have a matrix visual, in Rows I have (from differnt dimensions):

-Name from Dim1
-Parent from Dim2
-Client Sold from Dim3
-Client Pay from Dim 4
-Contract from Dim 5.

As 'values' I have some measures from the Fact table.

Now, I have as a requirement to show the ‘address’ of the Dim 4 as ‘Values’ too.

The data only makes sense if I drill down to the ‘client pay’ level… otherwise when aggregated, as expected, it just picks the ‘first address’ and makes no sense.

Is there a way to show blank, until the user drills down at the Dim4[Client Pay] level?

ps: I have tried both SELECTEDVALUE and ISINSCOPE and it doesnt work as I expect... Whenever I use them... the visual starts loading and it provides the address for ALL the clients! I want the matrix to only show data where there are values in the fact...

[Anonymous]

it works!

i just had to use 

Measure= if(ISFILTERED('Dim 4'[column]),Min(Fact[ClientPay_Fact]),BLANK()) 

I think you just missed the column 

[Anonymous]

it still doesnt work 😞

[Shishir22 · Accepted solution]

Hello  , 

Can you try creating a calculated column in your fact table using RELATED function and then try to use it

ClientPay_Fact = Related(Dim4[Client Pay]) 

Also, please try using -

Measure= if(ISFILTERED('Dim 4'),Min(Fact[ClientPay_Fact]),BLANK()) 

or

 Measure 2= if(HASONEVALUE(Fact[ClientPay_Fact]),Min(Fact[ClientPay_Fact]),BLANK()) 

Please mark it as solution if it solves your issue. Kudos are also appreciated.

Cheers,

Shishir