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 – Stay on track at every deal stage with delta-first guidance in Sales Close Agent
We are announcing the ability to stay on track at every deal stage with delta-first guidance in Sales Close Agent in Dynamics 365 Sales. This ...
Dynamics 365 Sales – Chat about sales opportunity agent insights from inside Sales agent
We are announcing the ability to chat about sales opportunity agent insights from inside Sales agent in Dynamics 365 Sales. This feature will ...
Dynamics 365 Sales – Deploy multiple Sales Qualification Agents in a single environment
We are announcing the ability to deploy multiple Sales Qualification Agents in a single environment in Dynamics 365 Sales. This feature will r...
Power BI Desktop Bridge (Preview)
Power BI Desktop Bridge (Preview)Power BI Desktop Bridge introduces a new way of working, allowing external applications and agents to interac...
Using REMOVEFILTERS in DAX user defined functions
Optimising DAX: Why Cardinality Matters
Column cardinality is one of the biggest factors in Power BI model size and query speed. This post explains why, and covers practical techniqu...
Beyond Attribution: Pipeline Intelligence from Marketing Activities with Dynamics 365 CE/CRM and Power BI
At New Dynamic, a marketing reporting project evolved into something much larger. What began as an effort to better understand marketing activ...
What’s Hot and New for Power BI Semantic Models in 2026 — A Conversation with Christian Wade | Fabric Insider Ep. 5
Christian Wade has been in the enterprise BI space longer than most. He was working with semantic models — Analysis Services, VertiPaq — long ...
Power BI DirectQuery Mode: A Better Choice Than You Might Think
For as long as I’ve been using Power BI – which has been from the beginning – the advice about which storage mode to choose ...