Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
Anonymous
Not applicable

DAX variable depends on Filters

Hello community,

 

I would like to declare my variable "Year". This variable will take the year filtered by the user. How can I manage it please? 

 

As an example, the user filters the visual on 2021, then my variable " VAR Year= 2021", if the filter is 2020 then "VAR Year =2020" etc.

 

Please can you help me 

 

THank you 

1 ACCEPTED SOLUTION
OwenAuger
Super User
Super User

Hello @Anonymous 

 

If you are assuming a single year will be filtered, then you can write:

VAR Year = SELECTEDVALUE ( SomeTable[Year] )

SELECTEDVALUE will return the value of Year if a single value is visible, otherwise BLANK.

You can specify a default value as the second argument of SELECTEDVALUE.

 

Does this work in your situation?


Owen Auger
Did I answer your question? Mark my post as a solution!
Blog
Twitter
LinkedIn

View solution in original post

2 REPLIES 2
OwenAuger
Super User
Super User

Hello @Anonymous 

 

If you are assuming a single year will be filtered, then you can write:

VAR Year = SELECTEDVALUE ( SomeTable[Year] )

SELECTEDVALUE will return the value of Year if a single value is visible, otherwise BLANK.

You can specify a default value as the second argument of SELECTEDVALUE.

 

Does this work in your situation?


Owen Auger
Did I answer your question? Mark my post as a solution!
Blog
Twitter
LinkedIn
Anonymous
Not applicable

Hello @OwenAuger ,

 

Thank you very much for your reply, it works well!!

 

Arnaud

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors