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
Real-Time Dynamics 365 Sales Alerts for Manufacturing Teams: Close Deals Faster
In the manufacturing industry, timing often determines whether a deal moves forward or ends up with a competitor. Sales representatives manage...
Building in the Agentic Era with Power BI and Fabric
Microsoft Build 2026 marks a major shift in how developers build data experiences with AI agents. Today we're announcing two capabilities that...
Power BI at Microsoft Build 2026: The Agentic Era of analytics
Microsoft Build 2026 brings the next generation of intelligent analytics to Power BI—where agents do the building, apps deliver insights ...
DAX User-Defined Functions (Generally Available)
DAX user-defined functions are now production-ready based on community feedback and internal validation. Their adoption during preview shows t...
Dynamics 365 Sales – Personalize outreach emails generated by Sales Qualification Agent
We are announcing the ability to personalize outreach emails sent by the Sales Qualification Agent in Dynamics 365 Sales. This feature will re...
Dynamics 365 Sales – Plan your sales portfolio with Sales Research Agent
We are announcing the ability to utilize Portfolio Planning to plan your sales portfolio using the Sales Research Agent in Dynamics 365 Sales....
We need to talk about... Dynamics 365 Sales... Release Wave 1 for 2026
Next in my blog, I will launch a series on the changes we can expect to see as part of Release Wave 1 for 2026. If you've been following my bl...
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...