Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello. I have a type/subtype structure in a single Table. It might be something like State and City. So...
Ohio
> Cleveland
> Columbus
Kentucky
> Louisville
Pennsylvania
> Pittsburgh
> Harrisburg
Users make slicer selections on the City. I need a DAX measure that tells me if two or more cities are SELECTED for any ONE state, and additionally returns the names of the selected cities.
So if the user selects Cleveland and Louisville, return nothing. If they select Cleveland AND Columbus, return the names of both.
I started writing something with the SUMMARIZE function to group the number of distinct cities for each state, but i can't work in the selected count part.
Can someone help? Thanks.
Make a clear example with input and your desired output. Because you write first:
So if the user selects Cleveland and Louisville, return nothing. If they select Cleveland AND Columbus, return the names of both. This do the measure 😉
Thank you 🙂
Proud to be a Super User!
Image attached. Thank you again.
Why do you not send it before. 🙂 I will try it tomorrow morning.
Proud to be a Super User!
Proud to be a Super User!
Thank you. That doesn't really work at all though. If one city is selected, it returns that city. If multiple cities are selected for several states, it returns nothing.
To add some clarity, if multiple cities are selected for ANY state, it should return the city/state groups that are selected.
User | Count |
---|---|
107 | |
87 | |
81 | |
76 | |
71 |
User | Count |
---|---|
112 | |
105 | |
96 | |
74 | |
66 |