Forum Discussion
Find Minimum Average Price
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.
1 Reply
You can use MINX and your measure to achieve that. Take some inspiration from this post.