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...
Need Help
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!

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Thanks for your response, but I can't share my PBIX file. But the issue is that in my file a one to one relationship between "Type" is not being accepted as a valid one and others have a circular dependency issue. And I have a date and type filter (from table 1) on the page which aren't working if they're not having an active relationship between the types or dates. 

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

        Hi  Anonymous ,

         

        Could you pls show some sample data with expected output?

         


        Best Regards,
        Kelly

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