Forum Discussion
AdministratorBelonging to two groups
Hello
I have the following zone table
What I want is to show in a table the following
With a segmentation I want to choose the zone/representative and show the sales of the chosen area.
The problem is that there are areas like Barcelona, which apart from having more subzones (here there is no problem since when I choose Barcelona the subzones come out), is that they also belong to a representative, in conclusion, Barcelona belongs to Barcelona delegation and a representative.
How can I indicate in the table of zones that Barcelona belongs to two groups and so from a segmentation to choose either barcelona as a delegation or barcelona as a representative (only barcelona will come out and not the subzones.)
Thank you.
3 Replies
- lbendlin
Super User
Please provide sample data that covers your issue or question completely.
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Please show the expected outcome based on the sample data you provided.
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523 
Syndicate_AdminHello
I may have explained it wrong, but I already provided the data.
Let me explain myself again.
I have a table with many zones, but there are zones that must belong to a "DelegationX" and also to a "DelegationXXX". I want to have a segmentation where I can choose the different delegations
Example: The Albacete area belongs to "Delegacion Valencia" and must also belong to "Delegacion Valencia 2". The data that must come out are the same regardless of the delegation you choose, but I must be able to choose each delegation separately.
To do this, I have a table with all the zones and a column where I put which delegation belongs, the problem as I commented, is how I can tell the table that a zone belongs to more than one delegation.
The table currently:
Thank you.
- lbendlin
please provide the sample data in usable format. A screenshot is not usable.
