Forum Discussion
Distinct count
Hi JamesBurke,
Thank you for reaching out to the Microsoft Fabric Forum Community.
The issue with both Green Buildings and Not Green Count returning the same result likely stems from the filtering context and the way you're referencing the Date table in your DAX expressions. To resolve this,use the ALL('Date') function to remove slicers and filters on the Date table. Ensure proper relationships between the FactUWP and Date tables.
If the issue still persists, please feel free to share more details with Sample data and expected output so that we can further investigate and help resolve it.If you find this response helpful, please consider marking it as the accepted solution and giving it a thumbs-up to support others in the community.
Thank you & regards,
Prasanna Kumar
Hi JamesBurke,
Just following up to see if the solution provided was helpful in resolving your issue. Please feel free to let us know if you need any further assistance.
If the response addressed your query, kindly mark it as Accepted Solution and click Yes if you found it helpful — this will benefit others in the community as well.
Best regards,
Prasanna Kumar