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 – Chat with your deal insights using ask-and-refine experience in Sales Close Agent (preview)
We are announcing the ability to chat with your deal insights using an ask-and-refine experience in Sales Close Agent in Dynamics 365 Sales. T...
Dynamics 365 Sales – Stay on track at every deal stage with delta-first guidance in Sales Close Agent (preview)
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 – Clone and share Sales Development agent configuration across teams
We are announcing the ability to clone and share Sales Development agent configuration across teams in Dynamics 365 Sales. This feature will r...
Power Pages – Support for Power BI Embed Token v2 for Power Pages
We are announcing the ability to utilize Power BI Embed Token v2 for Power Pages. This feature will reach general availability on May 30, 2026...
Dynamics 365 Sales – Identify important actions in the flow of work with Recommended Action
We are announcing the ability to utilize Recommended Action to identify the most important actions in the flow of work in Dynamics 365 Sales. ...
Dynamics 365 Sales – Uncover insights and risks to close more deals with Opportunity Research Agent
We are announcing the ability to uncover insights and risks to close more deals with Opportunity Research Agents in Dynamics 365 Sales. This f...
How to Automate and Email Dynamics 365 Sales Reports to Management
Introduction Every sales-driven organization runs on numbers, pipeline status, expected closures, rep-wise performance, forecast movement, and...