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

Hi, I just thought of another scenario I may want to have. I would also like to be able to return the value of say year 2010 (10) regardless of where the year slider is positioned. 

Jihwan_Kim's avatar
Jihwan_Kim
Super User
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 )