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
Dynamics 365 Sales – Carry out suggested actions faster and more effectively
We are announcing the ability to carry out suggested actions with built-in context and guidance directly within the flow of work in Dynamics 3...
Optimising DAX: VertiPaq Encoding Techniques
VertiPaq fits millions of rows in memory by compressing columns. Learn how value, hash and run-length encoding work, and what they mean for mo...
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...