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
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.
Dynamics 365 Sales – Skills for Copilot Cowork
We are announcing the ability to connect Dynamics 365 Sales to Copilot Cowork with Skills. This feature will reach general availability on Jun...
Dynamics 365 Sales – Redesigned Opportunity Research helps sellers understand deals and take action faster
We are announcing a redesigned Opportunity Research experience that helps sellers understand deals faster and take action with confidence in D...