Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

No respect filter when use table constructor with DAX


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

  • stevedep's avatar
    stevedep
    6 years ago

    Hi,

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

4 Replies

  • stevedep's avatar
    stevedep
    Icon for Memorable Member rankMemorable Member
    6 years ago

    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. 

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      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.

      • stevedep's avatar
        stevedep
        Icon for Memorable Member rankMemorable Member
        6 years ago

        Hi,

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