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 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
The Optimal Shape for Power BI Data
Why Star Schema Matters More Than Ever in the Age of AI It was over a decade ago that Matt first posted on The Optimal Shape for Power BI Data...
New Power Query experience in Power BI Desktop (Preview)
Authored by: Sara Lammini Rodriguez - Product Manager II, and Miguel Escobar - Senior Product Manager
Power BI Update - May 2026
Power BI May 2026 Feature Summary
Author: Katie Murray, Senior Program Manager - Power BI continues to evolve with updates that make it easier to explore data, generate insight...
The Updates and Future of Visualization in Power BI — Interview with Zoe Douglas | Fabric Insider Ep. 2
Fabric Insider Series | Episode 2 | Interview with Zoe Douglas, Feature PM at Microsoft If you have been following Power BI for a wh...
Dynamics 365 Sales – Get sales operations insights in Sales Research Agent
We are announcing the ability to get sales operations insights in Sales Research Agent in Dynamics 365 Sales. This feature reached general ava...