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
Deprecating Power BI Q&A
We are announcing the deprecation of Q&A, our legacy natural language tool, which will take place in December 2026. Moving forward, users ...
A Look At The Impact Of Calendar Based Time Intelligence On Power BI DirectQuery Performance
Calendar-based time intelligence (see here for the announcement and here for Marco and Alberto’s more in-depth article) is at least the ...
Boost Your Dashboards: The Role of Visual Calculations in Power BI
Visual Calculations in Power BI play a transformative role by allowing users to write calculations directly within a visual, simplifying analy...
Fix ANY Date Format in Excel with Copilot Function – no Power Query – no Macros!
Fix ANY Date Format in Excel with Copilot Function without any Macros. Got dates in multiple, different and difficult formats? No problem. ...
We need to talk about... Dynamics 365 Sales... Release Wave 2 for 2025
Next in my blog, I will launch a series on the changes we can expect to see as part of Release Wave 2 for 2025. Microsoft’s 2025 Release Wave ...
Power BI, Build Permissions And Security
If there is sensitive data in your Power BI semantic model that you don’t want some users to see then you need to use row-level security...