Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi,
I want my matrix to not display anything in the "first sector" column when the matrix is not expanded. In the below example, the sector column would show nothing.
However, when expanded, it would show the respective sector for each city:
Essentially, when the matrix is not expanded, having "first sector" doesn't really make sense unless you see the city it is associated with. Is there anyway to change the visual / make a measure etc?
Thanks
Solved! Go to Solution.
Hi, you have to find a way to return a different number in city/country.
A way could be to count the number of city. So when you are in the line of the country is > 1, when you are in the city line is one.
Something like this:
MEASURE =
var _count = DISTINCTCOUNT([City])
RETURN
IF(_count = 1, MAX([Sector], BLANK())
Mark as solution if i help you.
Ciao!
Thank you!
you're welcome
Hi, you have to find a way to return a different number in city/country.
A way could be to count the number of city. So when you are in the line of the country is > 1, when you are in the city line is one.
Something like this:
MEASURE =
var _count = DISTINCTCOUNT([City])
RETURN
IF(_count = 1, MAX([Sector], BLANK())
Mark as solution if i help you.
Ciao!
User | Count |
---|---|
77 | |
74 | |
62 | |
61 | |
45 |
User | Count |
---|---|
108 | |
102 | |
93 | |
83 | |
64 |