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
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
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...
The Benefits Of Using Direct Lake Mode In Power BI
This is a blog post I’ve been meaning to write for a long time. Since Fabric launched there has been a lot of focus on Direct Lake mode ...