Forum Discussion
Creating sub groups from mesure
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,
You can create a calculated column and filter on that column:
Region = SWITCH ( TRUE, CONTAINSSTRING ( Table1[Category], "France" ), "European", CONTAINSSTRING ( Table1[Category], "US" ), "American" )
2 Replies
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" )