topic Re: No respect filter when use table constructor with DAX in DAX Commands and Tips

No respect filter when use table constructor with DAX

Anonymous — Tue, 02 Jun 2020 16:10:35 GMT

No respect filter when use table constructor with DAX

I have a table with values distributed in columns, but I need to calculate on the graph as if it were the same axis.

When select period filter of dates, must show only values corresponding with select dates.

In table the first column is Date, second column is Vendor and de last column is Customer Satisfaction Survey.

Link for file

https://we.tl/t-e8us4WyiHL

Re: No respect filter when use table constructor with DAX

stevedep — Tue, 02 Jun 2020 16:43:07 GMT

Hi,

You need to unpivot the data first:

File is available here.

Kind regards, steve.

ps. please mark as solution when this is what you are looking for.

Re: No respect filter when use table constructor with DAX

Anonymous — Tue, 02 Jun 2020 16:57:40 GMT

Thanks Steve, but i need filter CSAT for Vendor.

In the solution you passed, it will be necessary to add a column of dates, but in this case it is necessary to make a table with all the necessary information.

I would like to execute all of these instructions in DAX.

Re: No respect filter when use table constructor with DAX

stevedep — Tue, 02 Jun 2020 17:04:17 GMT

Hi,

its possible to retain the vendor column so you can filter.

Re: No respect filter when use table constructor with DAX

Anonymous — Tue, 02 Jun 2020 17:43:49 GMT

Sorry. Steve, now i understand the solution. For application of the solution is necessary turn columns into rows.

I searched other ways, for not turn columns into rows. But thanks for solution, and i go implement in the my project.