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
Power BI Update - June 2026
Power BI June 2026 Feature Summary
This month, we’re continuing to focus on making every day work a little easier—whether that’s building reports, modeling data, or just getting...
AI-Powered Power BI reporting: From design to deployment with agent skills (Preview)
AI powered Power BI reporting skills is a collection of multiple skills that enables AI agents to automate report creation, from designing pag...
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...