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 – Get integrated inbound and outbound calling with Sales Hub dialer
We are announcing the ability to get integrated inbound and outbound calling with Sales Hub dialer in Dynamics 365 Sales. This feature will re...
What now for Power BI? The question I can’t escape
Everyone keeps asking me the same question: what now for Power BI? With Microsoft Fabric reshaping its identity and AI-generated dashboards ch...
Dynamics 365 Sales – Engage leads with deeper knowledge by connecting any data source to Sales Development agent
We are announcing the ability to engage leads with deeper knowledge by connecting any data source to a Sales Development agent in Dynamics 365...
Dynamics 365 Sales – Connect Fabric Lakehouse data to AI‑powered sales research
We are announcing the ability to connect Microsoft Fabric Lakehouse data to AI-powered sales research in Dynamics 365 Sales. This feature will...
Mastering DAX 3rd Edition Unplugged
Setting up Power BI Version Control with Azure Dev Ops
In this blog post is a way set up version control for Power BI semantic models (and reports) using the PBIP (Power BI Project) format, Azure D...
Dynamics 365 Sales – Find, filter, and sort using natural language with smart grid
We are announcing the ability to find, filter, and sort records using natural language queries directly within smart grid through Copilot Sear...
Dynamics 365 Sales – Boost decision making by using Visualize with Copilot
We are announcing the ability to boost data-driven decision making using Visualize with Copilot in Dynamics 365 Sales. This feature will reach...