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
Simplify Power BI DAX with Visual Calculations
Excel or Power BI: Why Start Over?
Dynamics 365 Sales Alerts: Native Notifications vs. Alerts4Dynamics – Which one is Right for You?
For an effective sales process, it is crucial to be up-to-date with important sales events. By staying abreast of these crucial moments, you g...
Power BI, M365 Copilot And The Importance Of DAX UDFs
This was a big week for Power BI Copilot with the announcement of a new direction for the feature. If you haven’t done so already, read ...
Power BI Update - July 2026
Extending agentic Microsoft Dynamics 365 Sales with MCP
MCP extends Dynamics 365 Sales agents with external data, tools, and actions, helping connect sales processes across business systems. The pos...
Extending agentic Microsoft Dynamics 365 Sales with MCP
AI agents are only as capable as the tools, skills, and information they can reach. In sales, the intelligence that drives great decisions—buy...
Microsoft Copilot (Microsoft 365): Power BI integration in M365 Copilot
This release enables M365 Copilot to reason over Power BI enterprise data and returns grounded answers directly from Power BI reports and sema...