Forum Discussion

Adam15's avatar
Adam15
Frequent Visitor
2 years ago
Solved

SelectedValue and Dates

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 ...
  • timalbers's avatar
    timalbers
    2 years ago

    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.

timalbers's avatar
timalbers
Icon for Skilled Sharer rankSkilled Sharer
2 years ago

Hi Adam15 ,

 

based on the information you gave, here is some advise:

  • Make sure you are using the exact same Date field in your slicer as you use for SELECTEDVALUE
  • Make sure the relationship between your date table and the fact table is set up correctly (maybe share here)
  • Also it is important how you set up the Last Selling Price measure (maybe you could share this one's DAX as well here)

Hope this helped you in some way already

 

Cheers

Tim

  • Adam15's avatar
    Adam15
    Frequent Visitor
    2 years ago

    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:

    Last Selling Price = Calculate(max(Invoice[Price]), all('Date'[Date]))
    I work in an industry where the last selling price is equal to the maximum.