Forum Discussion

sverderame's avatar
sverderame
Helper I
3 years ago
Solved

Obtaining a row value when using "Less than or equal too slicer (Year)

Obtaining a single row value when using "Less than or equal too slicer (Year)   I have a table that has 32 rows oy yearly values (year 2000 - 2032), each row has a widget value for its associated y...
Need Help
  • Jihwan_Kim's avatar
    Jihwan_Kim
    3 years ago

    Hi,

    I do not know how your data model looks like, but I tried to create a sample pbix file like below.

    Please check the below picture and the attached pbix file.

    I hope the below can provide some ideas on how to create a solution for your data model.

     

     

     

    Value maxyear measure: =
CALCULATE ( [Value total measure:], 'Year'[Year] = MAX ( 'Year'[Year] ) )
  • Jihwan_Kim's avatar
    Jihwan_Kim
    3 years ago

    Hi,

    Thank you for your message, and please check the below picture and the attached pbix file.

     

    Value 2010 measure: = 
CALCULATE ( [Value total measure:], 'Year'[Year] = 2010 )
sverderame's avatar
sverderame
Helper I
3 years ago

Hello, for some reason this DAX is not working for me. It applies the correct value from 2010 and higher but when I select 2009, the value turns "Blank"

 

Everything in your files seems to match mine, the relationships seem to be in order. I can't figure out why it is not working when I select a year previous to 2010.