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
Power BI Multilingual Reports Made Simple with User-Context-Aware Calculated Columns
Building a multilingual Power BI report has always been one of those requirements that sounded simple but turned out painful to implement. A F...
Simplified Oracle connectivity in Power BI (Preview)
Connecting Power BI to Oracle has historically meant extra provider installations and data gateway deployment — even for cloud-hosted database...
Migrating from embedded ODBC drivers to ADBC in Power BI and Fabric
If you use connectors like Databricks, Snowflake, or BigQuery in Power BI or Fabric, there’s an important change coming. Microsoft is moving f...
Power BI Update - June 2026
Power BI June 2026 Feature Summary
This month, we’re continuing to focus on making every day work a little easier—whether that’s building reports, modeling data, or just getting...
AI-Powered Power BI reporting: From design to deployment with agent skills (Preview)
AI powered Power BI reporting skills is a collection of multiple skills that enables AI agents to automate report creation, from designing pag...
Dynamics 365 Sales – Carry out suggested actions faster and more effectively
We are announcing the ability to carry out suggested actions with built-in context and guidance directly within the flow of work in Dynamics 3...
Optimising DAX: VertiPaq Encoding Techniques
VertiPaq fits millions of rows in memory by compressing columns. Learn how value, hash and run-length encoding work, and what they mean for mo...