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
Why should I complete Power BI Performance Load Testing & initial setup
It is becoming increasingly important to understand how the Power BI reports/Semantic Model that are being used in your organization are perfo...
Power BI Copilot, AI Instructions And Preventing The Use Of Implicit Measures
In yet another entry in my series on what you should be doing in Power BI Copilot AI Instructions, in this post I want to address the most dif...
Power BI Copilot Summaries honor AI Instructions to provide non-English language responses
In working with Power BI Copilot one of the feedback requests I hear from my customers is being able to support non-English languages. While p...
Updates to Copilot in Power BI: More ways to see, learn from, and ask about your report data
This blog draft gives an overview of updates to access and learn from report data via Copilot.