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
Required update for organizational authentication in Excel Power Query (Entra ID)
Excel Power Query is updating its authentication flow for Organizational Accounts (Microsoft Entra ID) to enhance security and reliability. Us...
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...