Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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...
Solved! Go to 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
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
it still doesnt work 😞
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
95 | |
76 | |
65 | |
51 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |