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
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