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
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...
No Code, No Tools: Documentation for Power BI and Fabric Using Fabric Skills and GitHub Copilot
Documentation is one of those things that every data team knows they should do — and almost nobody does well. You build a Power BI semantic mo...
Embed a Power BI Dashboard in Model Driven App – using Copilot Agent Kit as example
In this article, lets learn how to embed a Power BI Dashboard in a Model Driven App (MDA). We will cover: We use the Copilot Agent Kit (CAK) C...