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
Dynamics 365 Sales – Explore complex sales insights with Sales Research Agent
We are announcing the ability to explore sales insights using the Sales Research Agent in Dynamics 365 Sales. This feature reached general ava...
Dynamics 365 Sales – Modern, in-flow email template picker for Sequences
We are announcing a modern, in-flow email template picker for Sequences within Dynamics 365 Sales. This feature will reach general availabilit...
Predicting the Future: Using Power BI to Identify Your Most Profitable Agencies
In the 2026 federal landscape, "growth" is no longer a broad target—it’s a surgical strike. If your executive team is still making "bid/no-bid...
Custom FetchXML Aggregation in Power Pages — Build a KPI Dashboard Without Power BI
Overview Power BI is a great tool — but it requires additional licensing, an embed configuration, and adds complexity to your portal architect...
Power BI Update - April 2026
Power BI Integration with GITHUB
While Azure DevOps is usually the easiest choice for Microsoft users, connecting Power BI to GitHub is becoming a must-have skill for anyone u...
Power BI April 2026 Feature Summary
Welcome to the April Power BI update! Power BI’s April 2026 update is here, bringing continued improvements across Copilot and AI, reporting, ...
How I Built a Full Power BI Semantic Model in Minutes Using Agentic AI and GitHub Copilot
In this second part of my blog series, I will show you how I edited the required files and then created my semantic model by using the Agentic...
A whirlwind tour on User-context-aware calculated columns in Power BI!
Bye, bye translation headaches! With the new User-context-aware calculated columns, we can tackle certain challenges more convenient than ever...