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
A Practical Guide to use OneLake Security for OneLake Object, Row, and Column Security
In this blog post, I will show you how to configure OneLake security for a Microsoft Fabric Lakehouse. We will remove the default broad-access...
Remove Hardcoded Workspace and Item IDs with Fabric Variable Libraries to use Across Dev/Test/Prod
In this blog post I’m going to show you how you can use variable libraries with connection strings as well as items. This approach allows you ...
Using Python Notebooks to Merge Data into a Microsoft Fabric Lakehouse
In this blog post I am going to show you how to use a Fabric Python runtime notebook (This is the notebook which only uses Pure Python functio...
Using GitHub Copilot CLI to Build a Microsoft Fabric Lakehouse Table Health Pipeline
In this post I will show how I used GitHub Copilot CLI / Agent mode in VS Code to create a Microsoft Fabric pipeline that checks Lakehouse tab...
Seamlessly Moving Fabric Notebooks Across Workspaces with Lakehouse Auto-Binding and Git Integration
With the new Lakehouse Auto-Binding capability in Notebook Git integration, Fabric can now intelligently preserve and resolve the binding betw...
Accessing data between Private Link and Public Fabric Workspace using the Private Endpoint
In this blog post I show how it is possible to access data between a Private Link Workspace, where I want to read the data from my Public Work...
Creating a Private Link in Microsoft Fabric — No Public Access
In this blog post, I am going to walk through how I created a Private Link in Microsoft Fabric so that access routes over Microsoft’s private ...
How to set up a SharePoint Folder Shortcut using Workspace Identity in Microsoft Fabric
I really think it is ideal to use a workspace identity in Microsoft Fabric. This is because not only is it secure by default but not having to...
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...