Forum Discussion
Solved
Filtering a table
Hello, I have this table. Letter Number A 1 A 2 A 3 B 1 B 2 B 3 C 1 C 2 C 4 D 4 D 5 D 6 D 7 E 2 E 3 If i put a slicer on t...
thanks for the file this is what i needed
d_rohlfs
Resolver II
Resolver IIHi Flyn,
Because you are trying to slice on a table, you cannot summarize your 'Table'[Letter] column while the 'Table'[Number] column is in the same table. But, if the 'Table'[Number] column is not present in the table you should get your desired result.
If this is not acceptable, you could try doing some DAX with a Concatenate() function, but this gets a lot more complicated.
Ok I see. This is what i tried first but i wanted the output like a table.