i want to get Max Value of Measure. I use Maxx Function but the Value which its return it Average Value.
Please Guide How can i get Proper Max Value Using Measure.
Solved! Go to Solution.
Instead of using MAXX try MAX([your measure],0). This will pick the higher of the two scalar values [your measure] and 0. If your measure can go negative but you still want to pull that if it does you would do MAX([your measure],-9999999)
I am assuming that the Dates appearing in your Calendar visual have been dragged from the Calendar Table.
Hope this helps.
HEY @Ashish_Mathur THANKS FOR REPLY
Share the link from where i can download your PBI file.
Hello @M_OVAISJANZEB ,
Can you share the formula in your [MTD RPT] measure? Given your screen shot, what value are you wanting to see in your measure?
Learn how to create your own user groups today!
Click here to read more about the November 2021 Updates!
Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.