Forum Discussion

Chelly's avatar
Chelly
Frequent Visitor
2 years ago

Issue with SELECTEDVALUE in Power BI - Need Help

Hello Power BI community,

I'm encountering an issue with the SELECTEDVALUE function when using a slicer for a specific year. If I choose the year 2020, for instance, the result only includes data for that year (e.g., 1000), but I actually want to retrieve the value for years less than 2020 (e.g., 10000).

Here's the snippet of my code:


_test = CALCULATETABLE(
DISTINCT(table[code]),
table[Statut] = 2,
table[year] < SELECTEDVALUE('YearTable'[Year], 2022),
table[Levels] = 2
)

Any insights or suggestions on how to achieve this would be greatly appreciated! Thanks in advance.

Need Help
Tutorial Requests

3 Replies

  • lukiz84's avatar
    lukiz84
    Icon for Memorable Member rankMemorable Member
    2 years ago

    hi, try:

     

    VAR SelectedYear = SELECTEDVALUE('YearTable'[Year], 2022)

_test = CALCULATETABLE(
DISTINCT(table[code]),
table[Statut] = 2,
table[year] < SelectedYear,
table[Levels] = 2
)
    • Chelly's avatar
      Chelly
      Frequent Visitor
      2 years ago

      Appreciate your efforts, but the results remain unchanged.

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi Chelly ,

     

    You can refer to below steps:

    result =
VAR sel_ =
    SELECTEDVALUE ( YearTable[Year] )
RETURN
    IF ( MINX ( 'table', [year ] ) <= sel_, 1, 0 )

    Best Regards,
    Adamk Kong

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly