Forum Discussion
Solved
Getting an average purchased price
Hello all! I'm having a problem with a measure. Total QTY is ok, I want it to show the total purchased regardless the filter context. The problem is that I try to get the average price...
hello thank you for providing details,
kidly change the first measure i provided to :total qtty = CALCULATE(SUM(HelpBi[Purchase Qtty]),ALL(HelpBi),HelpBi[ID]=MAX(HelpBi[ID]))i added some sample to show you how it work:
please tell me if it works if it does please accept as solution to help other users
hello thank you for providing details,
kidly change the first measure i provided to :
total qtty = CALCULATE(SUM(HelpBi[Purchase Qtty]),ALL(HelpBi),HelpBi[ID]=MAX(HelpBi[ID]))i added some sample to show you how it work:
please tell me if it works if it does please accept as solution to help other users
Thank you so much Anonymous ! This was exactly what I was needing! 😀