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
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&...
Microsoft Sales Agent in Outlook and Teams: What It Means for Dynamics 365 Sales Add-Ins
If you have worked with Microsoft Dynamics 365 Sales for any amount of time, you already know the story. Your sales team spends most of their ...
CRM in the flow of work | Dynamics 365 Sales
What Separates High-Performing Dynamics 365 Sales and Contact Centers
If you’re evaluating a Dynamics 365 Sales partner or Dynamics 365 Contact Center partner, the decision isn’t just about features, timelines, o...
Connecting Power BI Semantic Models To Data Sources Automatically With Binding Hints
Did you know that you can configure your Power BI semantic model so that it automatically binds to a data source connection when you publish? ...