DistinctCount and AllExcept

[lancersc]

Hi!

Below is the DAX forumula without date. I want the distinctcount without being affected by filters except for GL account type and Invoice line.

Below is the counter, 67 is a distinctcount of all the rows which is affected by filter, and 89 is the distinct count with GL and Invoice filter, where the 89 value does not change when I pick any filters.

 

So in order to also get 67, I also need the date range to be added in the allexcept.

Yes I get the Total rows correct 

But when I pick a filter, the second number also changes

This is my only current problem, the date.

This is the date filter btw

[Anonymous]

Hi @lancersc 
I'm glad to hear that your issue is resolved. Please accept it as the solution so it can help other community members with similar problems solve it faster.
Thank you.

[Anonymous]

Hi @lancersc 
Thank you for reaching out microsoft fabric community forum.
Could you please provide a more detailed explanation of the issue you are facing? Additionally, could you share a sample PBIX file to address this query more efficiently.
Thank you.

[lancersc · Accepted solution]

Hello!

I can't share the PBIX file because it containts the company data BUT I figured it out. I made a separate Date table and made a relationship between the Main Table and Date Table.

Thanks anyways!

[Deku]

Do you have a date dimesion used for the slicer?

[lancersc]

Not sure what that is but