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
Understanding the Roles of Salesperson, Sales Team, and Sales Manager in Dynamics 365 Sales
In Dynamics 365 Sales, the concepts of Salesperson, Sales Team, and Sales Manager are essential parts of the sales hierarchy and security mode...
Power BI October 2025 Feature Summary
This month’s update brings exciting opportunities for learning and community engagement, including the upcoming Fabric Skills Fest and t...
Power BI Report Server September 2025 Feature Summary
PBIRS September 2025 Feature Summary
Automating Power BI Semantic Model Security with Fabric Semantic Link
You may be using standardized solutions like Fabric Unified Admin Monitoring (FUAM) or any other templated solution that comes with a semantic...
First Look At Fabric Graph: Analysing Power BI Import Mode Refresh Job Graphs
The new Fabric Graph database is now rolling out now and should be available to everyone within the next few weeks if you can’t see it a...
Dynamics 365 Sales – Connect AI agents to sales workflows using Model Context Protocol server – updated date
We are announcing the ability to connect Dynamics 365 Sales to your agents and assistants with the new Model Context Protocol server. This fea...
Empowering our customers to shape the future of data connectivity in Power BI and Microsoft Fabric
Discover how Microsoft is transforming data connectivity in Power BI and Microsoft Fabric with a community-driven approach. Learn how you can ...