Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I have a matrix that I'd like to put a BLANK() in for a value for the first row/category. In the image below if its expanded or not, hide the value circled in red for ColB. I've been able to create a measure using ISFILTERED but I'm unable to do anything but hardcode text for that field. I'm unable to use a value from the dataset if it's FALSE. Is there a way to hide just that value but display all the others for the expanded rows? It's taking the first value that's available which doesn't make any sense for the category as it applies to the expanded rows. Any ideas?
Solved! Go to Solution.
Think I solved it with the following measures. IsFiltered checks the second row that is displayed after expanding the first row to see if its filtered. Measure then says if it's not filtered display the minimum value of Column B. Each value in the second row can only have 1 value in Column B, since they repeat, I had to get the first value only for Column B.
IsFiltered = If(ISFILTERED(TableName[SecondCategory-Row]), BLANK(),True)
Measure = if([IsFiltered] = True, BLANK(),
CALCULATE(MIN(Query1[ColB]))
)
Think I solved it with the following measures. IsFiltered checks the second row that is displayed after expanding the first row to see if its filtered. Measure then says if it's not filtered display the minimum value of Column B. Each value in the second row can only have 1 value in Column B, since they repeat, I had to get the first value only for Column B.
IsFiltered = If(ISFILTERED(TableName[SecondCategory-Row]), BLANK(),True)
Measure = if([IsFiltered] = True, BLANK(),
CALCULATE(MIN(Query1[ColB]))
)
Hi @TCavins ,
It seems that you solved this problem, right? If so and if you'd like to, you could mark corresponding post as answer or share your solutions. That way, people who in this forum and have similar issue will benefit from it.
Best Regards,
Zoe Zhi
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
User | Count |
---|---|
93 | |
85 | |
76 | |
66 | |
62 |
User | Count |
---|---|
110 | |
96 | |
95 | |
64 | |
57 |