I have a bit of an odd conundrum. I have a requirement from my users to allow them to choose groupings from a slicer using a pbix file that consists of a single query table and a date dimension. I can’t at this stage do anything that will break bookmarks.
I created a slicer table and then I created an unpivoted table with just the groupings I wanted. I connected it to the main table with a calculated column using the following pseduo-Dax and conected it to my main table with a two way relationship:
Column = SWITCH( FIRSTNONBLANK('Grouping Choice('Grouping Table'[Group],1), "Choice 1", RELATED('Other Table'[Choice 1]), "Choice 2", RELATED('Other Table'[Choice 2), )
So far, so good. When they use it they are able to see the correct data. However, my users are now asking for multi-select. I figured “no problem, I will give them concatenated data.” I created a new measure that concatenates the choices. However, it won’t work in the calculated column, which always returns a single row with blank. Is it even possible to do what I am attempting?
The measure I created was similar to this:
Selected Grouping = VAR GroupString= CALCULATE(CONCATENATEX(VALUES('Group Choice'[Group]), 'Group Choice'[Group], "/ "))