View My Drafts
My matrix table sums those values together as displayed below:
I have to calculate the range for what is in the matrix not the dataset. From what I am gathering I cannot successfully tell PowerBI to find the MAX or MIN of a measure. I need something to find the MAX and MIN within the matrix not the dataset. If I use the below formula it will return a value of 5 not 10. Can anyone help with this?
This formula will give me the first number pulling the Highest value in the actual dataset. Is there anyway to tweak this to get the 10 that I need?
Highest Sales Day = MAXX (VALUES( dDates [Dates]), [Total Sales] )
Hi Nick, you can try out this code if it solves your problem
Hi Bao,I've used this DAX code to create a measure which returns the highest monthly value for the measure called "% Aware" shown in the below matrix.The DAX code below returns 56% which is perfect but I also need to get the name of the month with the highest % of awareness so that ultimately I can show something like "Highest month to date: Jul-20 56%"
Please find attached file. I hope this helps! I added a date table as you will see.