Forum Discussion
DistinctCount and AllExcept
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
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!
5 Replies
Do you have a date dimesion used for the slicer?
Not sure what that is but
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.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!
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.
