Creating sub groups from mesure

[Anonymous]

Hello, 

I would like to split those categories knowing that I cannot change the Data. For exemple i would like to hide all the non European country from the list.

[Anonymous]

Thank you Sir !

[DataInsights · Accepted solution]

@Anonymous,

You can create a calculated column and filter on that column:

Region = 
SWITCH (
    TRUE,
    CONTAINSSTRING ( Table1[Category], "France" ), "European",
    CONTAINSSTRING ( Table1[Category], "US" ), "American"
)