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 fo...
Need Help
Tutorial Requests
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.