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
PBIR will become the default Power BI Report Format – Get Ready for the Transition
Starting in January 2026, all new reports created in both Power BI Service and Desktop will use the PBIR format by default, and existing repor...
Linking Queries Run From DAX Studio To Workspace Monitoring And The Capacity Metrics App
A few weeks ago I wrote a blog post about how you can now link event data from Workspace Monitoring to data in the Fabric Capacity Metrics App...
Power BI MCP Tuner Server and does it reduce capacity requirements – Part 4
This blog post is about using MCP to tune DAX and then using the Automated Load Testing does it reduce capacity. I originally did not plan for...