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 - 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...
Using Fabric Operations Agents And Workspace Monitoring With Power BI
This week, in the announcement about support for Fabric Pipelines in Workspace Monitoring, I noticed that it came with an Operations Agent tha...
Dynamics 365 Sales – Teams owned opportunities to be researched by Sales Opportunity Agent
We are announcing the ability to utilize the Sales Opportunity Agent to research opportunities owned by specific Owner teams in Dynamics 365 S...