Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hello,
I'm trying to make a report that shows the stock size, prize and total value of different items. I need to tell the total value using different approaches: Value when bought, Value of the average last 6 months selling price, Value on the last selling price. And I need to use a slicer to change the date I'm checking.
When I'm using this measure, it can show the current value on last selling price on febr 29:
Solved! Go to Solution.
Could you just leave out the ALL( 'Date'[Date] ) of the "Last Selling Value" measure.
This is an explicit filter context which prevents the slicer filter from filtering your dates.
Could you just leave out the ALL( 'Date'[Date] ) of the "Last Selling Value" measure.
This is an explicit filter context which prevents the slicer filter from filtering your dates.
It works for every product we sold that day, but for those we haven't it gives blank back.
edit: I got it, I just had to replace the Invoice to Depot in the Summarize.
Hi @Adam15 ,
based on the information you gave, here is some advise:
Hope this helped you in some way already
Cheers
Tim
The first two is good, I can't really show picture, because the tables are on my native language, I just translated the columns when I asked.
This is the measure for the last selling price:
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
23 | |
8 | |
7 | |
6 | |
6 |
User | Count |
---|---|
27 | |
12 | |
10 | |
9 | |
6 |