I am trying to find the minimum average value of a data set excluding negative values.
Right now I am using 'Min Price = CALCULATE(MIN('Main DATA'[Customer Sales]),'Main DATA'[Customer Sales] >0)' but this seems to be taking in purely the lowest price, and not the lowest average price, which is what I'm looking for.
I already have a formula set up for average value, there has to be a work around for this, but I'm drawing a blank.
You can use MINX and your measure to achieve that. Take some inspiration from this post.
Did I answer your question? Give your kudos and mark my post as a solution!
Proud to be a Super User!
You can use MINX and your measure to achieve that. Take some inspiration from this post.
Did I answer your question? Give your kudos and mark my post as a solution!
Proud to be a Super User!
Helpful resources
New forum boards available in Real-Time Intelligence.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
Power BI Monthly Update - May 2024
Check out the May 2024 Power BI update to learn about new features.
