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
Hi Anonymous !
I'm copying the table below with an extra column (productId).
The problem of using ALL is that it removes the product filter and I need the measure to calculate the average price for the selected product so using ALL is not working.
| Date | Product Id | Purchase qty | Price | Total QTY | Average Price |
| 30/12/2021 00:00 | 149 | 276 | 179.7 | 1028 | 180 |
| 31/12/2021 00:00 | 149 | 471 | 177.57 | 1028 | 178 |
| 31/12/2021 00:00 | 149 | 281 | 177.57 | 1028 | 178 |
| 4/1/2022 00:00 | 149 | 0 | 179.7 | 1028 | 180 |
| 7/1/2022 00:00 | 149 | 557 | 172.17 | 1028 | 172 |
| 7/1/2022 00:00 | 149 | -557 | 172.17 | 1028 | 172 |
| 12/1/2022 00:00 | 149 | -557 | 0 | 1028 | 0 |
| 12/1/2022 00:00 | 149 | 557 | 0 | 1028 | 0 |
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! 😀