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
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...
Power BI on a Mac: I Love It
I Put 11 Power BI Secrets to The EXPERT Test
How Generative AI Is Revolutionizing Dynamics 365 Sales (2026 Guide)
Introduction The world of sales has changed dramatically over the past few years. Sales professionals are no longer expected to spend countles...
Microsoft Viva: Create and customize Power BI reports
Microsoft Viva Insights will allow eligible users to create, customize, and save supported Power BI reports, including adjusting periods, filt...
Agentic CRM Readiness: What AI-First CRM Means for Microsoft Dynamics 365 Sales Teams
Sales leaders are starting to ask a different kind of CRM question. The question is no longer only whether Microsoft Dynamics 365 Customer Eng...