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.
Go to Solution.
View solution in original post
@MattAllington Thank You so much
thanks to all @MattAllington @MattAllington @jdbuchanan71
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 create this measure
but still getting incorrect value.
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?
@jdbuchanan71 I USE THIS
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.
@Ashish_Mathur THERE IS SOME CONFIDENTIAL DATA WHICH I CANT SHARE. there is any other way ???
Read the announcement for more information!
We're rolling out new Kudos Given badges. Find out how many Kudos you've given.
Get an overview of the events and great community content from November.
Find out where you can attend!