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
Microsoft 365 Usage Analytics Power BI template app will be retired
The Microsoft 365 Usage Analytics Power BI template app will be retired, with new downloads ending June 1, 2026, and support ending August 1, ...
Dynamics 365 Sales – Improve opportunity data completeness with AI-powered data enrichment
We are announcing the ability to improve opportunity data completeness with AI-powered data enrichment in Dynamics 365 Sales. This feature wil...
Power BI integration with Microsoft 365 Copilot
Starting June 2026, Microsoft 365 Copilot will integrate with Power BI in Frontier tenants, enabling users to ask questions grounded in Power ...
Optimising DAX: How VertiPaq Stores Your Data
VertiPaq stores Power BI data column-by-column rather than row-by-row. That makes aggregations fast and cross-column queries the trickiest par...
Optimising DAX: A Series Introduction
Optimising DAX in Power BI: VertiPaq storage, compression, model design, how queries run through the storage, formula engines, and performance...
Power BI File Formats Explained: PBIX vs PBIT vs PBIP vs PBIR
Power BI files come in multiple formats. If you have been working with Power BI Desktop for a while, you probably know the PBIX format well. B...
Power BI Tenant Migration: Trade-offs, risks, and realities
Author: Winnie Li, Cloud Solution Architect