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 Query tenant setting supports ODBC to ADBC transition
Microsoft will introduce a tenant-level setting to support transitioning Power Query from ODBC to ADBC, improving data connectivity performanc...
Microsoft Entra ID single sign-on for the Denodo connector in Power BI (Preview)
When you configure a Denodo data connection for Entra ID SSO, users querying a semantic model in DirectQuery mode are authenticated to Denodo ...
Business Central 2026 release wave 1 (BC28.2): Power BI Report Deployments (Centralized Management of Power BI Apps)
Hi, Readers.Dynamics 365 Business Central 2026 wave 1 (BC28.2) is generally available. More details: Cumulative Update Summary for Micros...
Protect once, enforce everywhere: Protection policies for Power BI (Generally Available)
How to use sensitivity labels and Protection Policies to secure your Power BI estate — and why it matters more than ever in the age of AI.&nbs...
Dynamics 365 Sales Integration with Business Central: Native, Custom, or Third-Party?
Connecting your CRM and ERP should mean one thing: your sales team sees accurate, current data from Business Central inside Dynamics 365 Sales...
New Book: “Extreme DAX” 2nd Edition
“Extreme DAX” by Michiel Rozema, Madzy Stikkelorum and Henk Vlootman Continuing my series of not-reviews of the latest Power BI-re...
Fabric App | Rayfin CLI | Create a Power BI Report
In my previous article : Build your first Fabric App using Rayfin CLI we learned how to create a Fabric App using Rayfin CLI After completing ...
Microsoft Entra ID single sign-on for the Starburst connector in Power BI (Preview)
When enabling Microsoft Entra ID single sign-on (SSo) for Starburst (Preview) report viewers querying semantic models in DirectQuery mode auth...
Workspace outbound access protection for Power BI reports (Preview)
Workspace outbound access protection (OAP) is a workspace-level control in Microsoft Fabric that lets you constrain where the data inside a wo...