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
Power BI Org Chart: Impress HR in 10 Minutes!
3 hours ago
Transforming Operations with Power BI Insights!
18 hours ago
Dark Theme Report Example in Power BI✌️
1 day ago
Finding Events Linked To A Specific Power BI Visual In Fabric Workspace Monitoring
Over the last few years one topic I have blogged about several times is how to link the detailed data about DAX query execution that can be fo...
1 day ago