Forum Discussion
Dynamic Comments DAX
No, it's because VALUES returns multiple values. Which is why it's not called VALUE. A measure has to return a single value for each filtering context. If you're trying to display multiple values from the Commentary1 column for each row, you'll need to use the CONCATENATEX function. If there's only one Commentary1 value for each row you can probably use FIRSTNONBLANK.
Gabrielmm This sounds more like a layout issue. If your column and level are column names you need to unpivot so the data is in rows. Then everything will work as you expect. Here is a screenshot of sample data.
The overall table layout is shown, then i use a slicer and a table to show the filter. The overall table is excluded from the slicer filtering interaction which is why it is not filtered.
I'm close to have it working ,It's like this:
It's maybe because I have blanks?