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 Update - September 2025
Power BI September 2025 Feature Summary
The Power BI September 2025 Feature Summary introduces updates for users and coincides with FabCon Vienna! This release introduces several key...
How To Get The Details Of Power BI Operations Seen In The Capacity Metrics App
It’s the week of Fabcon Europe and you’re about to be overwhelmed with new Fabric feature announcements. However there is a new bl...
Deprecation of Power BI Integration within SharePoint Lists and Libraries
Today, we are announcing the retirement of the Power BI integration within SharePoint lists and libraries. This change impacts customers who c...
AI and Agentic Development for Power BI
New Fabric Tenant Setting: “Set alert” Button Visibility for Power BI Users
A new Microsoft Fabric tenant setting will make the “Set alert” button visible to all Power BI web users, enabling them to create Fabric Activ...
What Happens When Power BI Direct Lake Semantic Models Hit Guardrails?
Direct Lake mode in Power BI allows you to build semantic models on very large volumes of data, but because it is still an in-memory database ...