Forum Discussion

AndresOHV's avatar
AndresOHV
Frequent Visitor
3 years ago
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...
  • Anonymous's avatar
    Anonymous
    3 years ago

    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

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
3 years ago

AndresOHV Perhaps try CALCULATE([Total Qty], ALL('Table')

  • AndresOHV's avatar
    AndresOHV
    Frequent Visitor
    3 years ago

    Hi Greg! Thank you for your answer.

    That's not working, I think because I need to keep the filter of a specific product, using ALL removes that filter.