DAX – Getting Distinct Count on Dimension table for Offices that have had Sales
I had a challenge when I was looking to get the Distinct Count of Offices only for the Offices that had Sales. The reason for this measure is to get the % out of all Offices who had Sales. Below is how I solved this. What I did first was to create the following measure, the issue was that this...
The post DAX – Getting Distinct Count on Dimension table for Offices that have had Sales appeared first on FourMoo | Power BI | Data Analytics.
Published on:
Learn moreRelated posts
Visualising Power BI Performance Analyzer Data With A Vibe-Coded Custom Visual
Performance Analyzer is now available in the browser, not just in Power BI Desktop! Actually everyone got excited about this back in September...
Power BI 2025 holiday recap: A decade of innovation and impact
2025 was a monumental year for Microsoft Power BI, marked by its 10-year anniversary and a series of community celebrations, global contests, ...