Issue with SELECTEDVALUE in Power BI - Need Help

[Chelly]

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.

[Anonymous]

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

[lukiz84]

hi, try:

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

_test = CALCULATETABLE(
DISTINCT(table[code]),
table[Statut] = 2,
table[year] < SelectedYear,
table[Levels] = 2
)

[Chelly]

Appreciate your efforts, but the results remain unchanged.