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
No Code Power BI: How to Use Claude and the Power BI Modeling MCP Server
What if you could build a complete Power BI semantic model — date table, time intelligence measures, relationships and all — without touching ...
Power Query, Dataflows, and What’s Next — A Conversation with Miguel Escobar | Fabric Insider Ep. 3
Power Query is one of those tools that has been close to my heart for a very long time. I wrote a full book on it, I have trained thousands of...
Microsoft Cans Power BI App for Microsoft 365 Usage
Microsoft has announced that the Microsoft 365 Usage Analytics Power BI app will retire on August 1, 2026. The alternative is the usage report...
Dynamics 365 Sales 2026 Wave 1: Turning AI into Your Competitive Advantage
Endeavor4 CRM and AI Advisory Services: We have highlighted 3 new features that follow recent Microsoft Copilot adoption trends. For decades, ...
Dynamics 365 Sales – Accelerate Sales Opportunity Agent deployment with simplified admin configuration
We are announcing the ability to accelerate Sales Opportunity Agent deployment with simplified admin configuration in Dynamics 365 Sales. This...
Sales Research Agent | Dynamics 365 Sales
Microsoft 365 Usage Analytics Power BI template app will be retired
The Microsoft 365 Usage Analytics Power BI template app will be retired, with new downloads ending June 1, 2026, and support ending August 1, ...
Dynamics 365 Sales – Improve opportunity data completeness with AI-powered data enrichment
We are announcing the ability to improve opportunity data completeness with AI-powered data enrichment in Dynamics 365 Sales. This feature wil...