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
Calculate(), DAX Fusion And Filters On 0 In Power BI
Here’s a fun DAX performance tip that I found this week. Do you have measures that use Calculate() with a filter on a numeric column? Is...
Power BI Report Server January 2026 Feature Summary
Welcome to January 2026 Power BI Report Server feature summary! These updates bring new capabilities and enhancements across Reporting and Vis...
Power BI Update - January 2026
Power BI January 2026 Feature Summary
IMPORTANT NOTE: The January Power BI Desktop release began rolling out today (1/20). Updates may take time to reflect in the desktop release. ...
Introducing Markers in Azure Maps for Power BI
We’re announcing a powerful new capability in the Azure Maps Visual for Power BI: Markers. This feature makes it easier than ever for organiza...
Measuring Time To Display For Image Visuals In Power BI With Performance Analyzer
Carrying on my series on troubleshooting Power BI performance problems with Performance Analyzer, another situation where a report may be slow...