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 April 2026 Update: What’s New and Why It Matters
Microsoft just pushed one of its most practical Power BI updates of the year. Here is everything that changed, explained. What is in the April...
Dynamics 365 Sales – Personalize opportunity research in Sales Close Agent
We are announcing the ability to personalize opportunity research in Sales Close Agent in Dynamics 365 Sales. This feature will reach public p...
Dynamics 365 Sales – Get lead research and next best actions in Sales Home
We are announcing the ability to get lead research and next best actions in Sales Home in Dynamics 365 Sales. This feature will reach public p...
CRM in the flow of work | Dynamics 365 Sales
Power BI May 2026 Feature Summary
Welcome to the May Power BI update!Power BI continues to evolve with updates that make it easier to explore data, generate insights, and build...
Agentic AI in Power BI and Fabric, Part 3: Agentic AI in Action with GitHub Copilot and Power BI Modeling MCP
In the previous blog, I covered the practical setup for agentic AI workflows with VS Code, GitHub Copilot, and safe local MCP testing. I…...
Power BI Semantic Model Memory Errors, Part 5: The “Maximum Allowable Memory Allocation” Error
This is a very late addition to the series of posts I wrote back in 2024 and which started here on Power BI memory errors. It’s about a ...
Unlocking deeper Copilot insights with enhanced Power BI filtering
Starting late May 2026, Viva Insights admins can enable reserved and custom attributes as filters in Power BI reports, allowing deeper, busine...
Exam AB-210: Dynamics 365 Sales AI Consultant Associate
Indeed the 3rd exam related post in just over a week – it’s a busy (new) certification release season at the moment! This time it&...