Grouping results in a report table

[r6raven]

Hi everyone!

I'm using Power BI Desktop to create a catalog of sorts and the idea is for users to select whatever options are appropriate across three slicers (could be any combination of 0-3 filters) and I need the resulting table to remove duplicate values based on a subset of the columns (meaning they are not duplicates across all five columns, so it's more of a grouping based on the first three columns).

The below shows the relationship, a sample of the source data, the current output, and what I'm trying to achieve. Can anyone confirm first if this is possible with tables/slicers or if I need to approach it another way, and if it is possible, how I can group the output?

Thanks in advance!

Master File		Mapping File
Language ID	1:*	Language ID	*Note: cross-filter direction: single
Language Text		State
Is Special?		City
[Other supporting info]

MASTER FILE
Language ID	Language Text	Is Special?
A	This field represents the language specific to identifier A.	Yes
A	This field represents the language specific to identifier A.	Yes
A	This field represents the language specific to identifier A.	Yes
A	This field represents the language specific to identifier A.	Yes
A	This field represents the language specific to identifier A.	Yes
A	This field represents the language specific to identifier A.	Yes
B	This field represents the language specific to identifier B.	No
B	This field represents the language specific to identifier B.	No
C	This field represents the language specific to identifier C.	Yes
C	This field represents the language specific to identifier C.	Yes
C	This field represents the language specific to identifier C.	Yes
C	This field represents the language specific to identifier C.	Yes

Using slicer to filter by State=California returns:
A	This field represents the language specific to identifier A.	Yes	California	Los Angeles
A	This field represents the language specific to identifier A.	Yes	California	San Francisco
A	This field represents the language specific to identifier A.	Yes	California	Hollywood
B	This field represents the language specific to identifier B.	No	California	Hollywood
C	This field represents the language specific to identifier C.	Yes	California	San Francisco
C	This field represents the language specific to identifier C.	Yes	California	Hollywood
Want it to return:
A	This field represents the language specific to identifier A.	Yes	California	[Any]
B	This field represents the language specific to identifier B.	No	California	[Any]
C	This field represents the language specific to identifier C.	Yes	California	[Any]
Using slicer to filter by Is Special = Yes returns:
A	This field represents the language specific to identifier A.	Yes	California	Los Angeles
A	This field represents the language specific to identifier A.	Yes	California	San Francisco
A	This field represents the language specific to identifier A.	Yes	California	Hollywood
A	This field represents the language specific to identifier A.	Yes	Nevada	Reno
A	This field represents the language specific to identifier A.	Yes	Nevada	Vegas
A	This field represents the language specific to identifier A.	Yes	Texas	Houston
C	This field represents the language specific to identifier C.	Yes	California	San Francisco
C	This field represents the language specific to identifier C.	Yes	California	Hollywood
C	This field represents the language specific to identifier C.	Yes	Nevada	Vegas
C	This field represents the language specific to identifier C.	Yes	Iowa	Des Moines
Want it to return:
A	This field represents the language specific to identifier A.	Yes	[Any]	[Any]
C	This field represents the language specific to identifier C.	Yes	[Any]	[Any]
Using slicer to filter by City = Hollywood returns:
A	This field represents the language specific to identifier A.	Yes	California	Hollywood
B	This field represents the language specific to identifier B.	No	California	Hollywood
C	This field represents the language specific to identifier C.	Yes	California	Hollywood
This is appropriate!

[r6raven]

Apologies, that formatting did not post in the way it was laid out in the preview... Just to clarify, the state and city are separate columns and the Yes/No in the output references the "Is Special" value.