Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Filter not working as expected

Hi,

 

I created a new table using summarizecolumns() and both the new table and source table have a column "Type". I have a dropdown filter for Type on the page which is not impacting the values of the new table. I tried creating a relationship but it said error due to circular dependency. I want to be able to filter out values based on "Type".

 

Any help would be appreciated.

Need Help

13 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    5 years ago

    Anonymous , First of all, slicer values are not taken by new table.

     

    Share the table script to check. Try to use summarize in place summarizecolumns and check if join works

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Hi, thanks for your response. Can you please elaborate on why slicer values don't affect the new table? Also the DAX Query for creating the new table is:

      Table2 = SUMMARIZECOLUMNS(Table1[Type],Table1[Date].[Year],Table1[Date].[MonthNo],"Number of rows", COUNT(Table1[ID]))

      • v-kelly-msft's avatar
        v-kelly-msft
        Community Support
        5 years ago

        Hi  Anonymous ,

         

        As tested here,it works fine,no error returns.

         

        Could you pls share your .pbix file for test?Remember to remove the confidential information.

        For my .pbix file,pls see attached.

         

        Best Regards,
        Kelly

        Did I answer your question? Mark my post as a solution!