Filter with slicer giving wrong results

[Anonymous]

I have the below measure, and its not giving me the right result. On the page I'm using this measure, I'm using a slicer. However, the data the slicer is filtering, isn't on the "Members" table. 

The way I have this written, shouldn't it ignore ANY filtering that could be applied to the "Members" table? When I have the Slicer on "ALL", it gives me the correct value ie: The count of members with created at date BEFORE 10/31/2019. However, when I select an option in the slicer, it gives me the wrong result. 

# of Members =
CALCULATE (
COUNT ( 'Members'[id] ),
FILTER ( ALL ( 'Members' ), 'Members'[createdAt] <= DATE ( 2019, 10, 31 ) )
)

Thanks in advance! 

Jim

[Anonymous]

Hi @Anonymous ,

I did a test but the error you mentioned didn't appear.

Could you share some sample data and the expected result to have a clear understanding of your question please? I can do some tests for you.

You can save your files in OneDrive, Google Drive, or any other cloud sharing platforms and share the link here.

Best Regards,

Yuna

[OwenAuger]

Hi @Anonymous 

Could you post a sample pbix file or more details on the data model, and the visual where you are displaying this measure?

You are correct that the measure itself should effectively remove any filters on the 'Members' table.

It's hard to say, but it could be related to DAX auto-exist and the queries generated by Power BI using SUMMARIZECOLUMNS - see discussion here:

• https://community.powerbi.com/t5/Desktop/Suspected-BUG-when-using-ALL-with-multiple-non-ignored-slicer/td-p/506096 
• https://www.sqlbi.com/articles/understanding-dax-auto-exist/

Owen