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
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 ...
How AI Agents in Dynamics 365 Sales Are Changing the Way Sales Teams Work
Sales teams today are expected to do more, faster, with less manual effort and less guesswork. That is the exact gap Microsoft is closing with...
Optimising DAX: Model Design Comparisons and Testing Tips
Star schema vs flat table vs header/detail - which Power BI model design gives you the best performance? This post compares all three and cove...
Tips to Export Data To Data Lake From MS Dynamics 365 CE And Use It In Power BI.
Integrating Dynamics 365 with Azure Data Lake allows you to continuously sync operational data for cost-effective big data analytics, AI workl...
Dynamics 365 Sales – Enable Automatic CRM Record Linking and Suggested Updates for Accounts, Contacts, and Leads
We are announcing the ability to enable Automatic CRM Record Linking and Suggested Updates for Accounts, Contacts, and Leads in Dynamics 365 S...
The Power BI Expert Is GONE. Now What?
Dynamics 365 Sales – Copy opportunities for repeat deals
We are announcing the ability to use the copy opportunity feature to start a new one in Dynamics 365 Sales. This feature will reach general av...
Deep dive into tooltip options in Power BI visuals (Generally Available)
Discover how Power BI’s tooltip (Generally Available) options help you tailor hover experiences—from curated field lists and sentence-style in...