Exporting a Power BI Visual data to a CSV File in SharePoint
In this blog post I am going to demonstrate how to use the new Power Automate Flow to extract data from a DAX measure into a SharePoint CSV file. I got this idea after reading the blog post from the Microsoft Power BI Team: Unlocking new self-service BI scenarios with ExecuteQueries support in Power Automate | Microsoft Power BI Blog…
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…
How to get multiple slicer items filtered using the DAX TREATAS function
Quite often I wanted to get the data a slicer quickly and easily where multiple items are selected. I then wanted to use the slicer items to filter my measure. The first thing that I did was to manually hard code the values to make sure that I was getting the correct values with the following measure below. EVALUATE ROW…
Get Power BI Desktop to write the DAX for you
Recently I had to get some data from a Power BI Dataset. At first, I started writing the DAX using the fantastic DAX Studio. Then a thought occurred to me, what if I could get the DAX already written and change it to my requirement. This would save me a lot of time and effort. I love the quote from…
Using DAX to calculate Cumulative Target amount split into individual months
I had a requirement to take the overall target amount and split it for each month. But also, for it to be cumulative for each month going forward. The Target amount was 600,000 per month This is what the DAX measure looked like Target by Month = VAR MyTarget = 6 * 6000000 VAR TargetPerMonth = DIVIDE ( MyTarget, 6…
A Real implementation of Approximate Distinct Count vs DISTINCTCOUNT is 7X faster!
I am very fortunate to have known Phil Seamark for quite some time. And quite a while ago we were chatting, and Phil mentioned that he had this idea that he could get an approximate distinct count working where it could be VERY close to the actual DISTINCTCOUNT (Using DAX) If you are unaware one of the most expensive DAX…
How to see what the actual values are in a FILTER when using a DAX Measure
I was working with a customer trying to get them to better understand DAX and one if the things that is difficult to understand is how the filtering works in DAX. The challenge I have found is that when using filters in a DAX measure I cannot visually see what is happening within the DAX Filter. Below I will show…
DAX – How to get a line break in a DAX measure for Labels or Titles in a Power BI report?
Once again, I really enjoy working with Power BI and in the data and analytics space. I was at a customer and they were drilling through between pages, and I wanted to put in what the filter selections were when they drilled through to the new page. This would allow them to easily see what had been on the previous…
DAX – Calculating the difference between 2 selections on a Slicer
Once again, I really enjoy answering questions on the Power BI Community, it keeps me challenged on how to find solutions to people’s requirements. This time the challenge was that a user on the forum was looking to calculate the difference between 2 selections made on a slicer. In this example the slicer was on a Product. Below is the…
When working with long measures in #PowerBI, it is easier to create them in the Data View
I have been working with a lot of DAX at the moment and the new DAX area is awesome. What I have found at times when working in the Report View, is that when I edit the DAX measures, I sometimes have to click on the arrow multiple times in order to get it to back up. This can be…