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
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...
Dynamics 365 Sales – Engage leads with deeper knowledge by connecting any data source to Sales Development Agent
We are announcing the ability to engage leads with deeper knowledge by connecting any data source to the Sales Development Agent in Dynamics 3...
Dynamics 365 Sales – Ensure precise customer interactions with fine-tuned Sales Qualification Agent
We are announcing the ability to ensure precise customer interactions with fine-tuned Sales Qualification Agent in Dynamics 365 Sales. This fe...
Turning Copilot into a system of action with Dynamics 365 Sales and Service plug-ins in Copilot Cowork
Copilot Cowork is where people delegate multi-step, multi-source work and review it, drawing across records, knowledge, email, and meetings, a...
Org apps with audiences for Power BI and Fabric (Generally Available)
Announcing general availability of org apps in Power BI and Fabric, including one of the most requested capabilities: audiences.