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
Deep dive into tooltip options in Power BI visuals (Generally Available)
Discover how Power BI’s tooltip (Generally Available) options help you tailor hover experiences—from curated field lists and sentence-style in...
No Code, No Tools: Documentation for Power BI and Fabric Using Fabric Skills and GitHub Copilot
Documentation is one of those things that every data team knows they should do — and almost nobody does well. You build a Power BI semantic mo...
Embed a Power BI Dashboard in Model Driven App – using Copilot Agent Kit as example
In this article, lets learn how to embed a Power BI Dashboard in a Model Driven App (MDA). We will cover: We use the Copilot Agent Kit (CAK) C...
Understanding The “Database Was Evicted To Balance The CPU Load” Error In Power BI
A few months ago I wrote about a rare error – the “Maximum allowable memory allocation” error – that may occur when th...
Watch AI Build a Complete Power BI Report
Deep dive into visual calculations: Adding calculations directly to your Power BI visuals (Generally Available)
Visual calculations (Generally Available) in Power BI, making it easier to add DAX calculations directly to the visual where they’re used.
Optimizing a Sales KPI Report in Power BI for Better Sales Visibility
Optimizing a Sales KPI Report in Power BI for Better Sales Visibility Introduction Sales teams work with a lot of data every day, including le...
Optimising DAX: The Cost of Relationships
Relationships in Power BI aren't free. This post explains how the cardinality of the relationship key determines traversal cost, and why this ...