Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
ovonel
Post Prodigy
Post Prodigy

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

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...

1 ACCEPTED SOLUTION
Shishir22
Solution Sage
Solution Sage

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

Cheers,
Shishir

View solution in original post

3 REPLIES 3
ovonel
Post Prodigy
Post Prodigy

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 

ovonel
Post Prodigy
Post Prodigy

it still doesnt work 😞

Shishir22
Solution Sage
Solution Sage

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

Cheers,
Shishir

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.