cancel
Showing results for
Did you mean:
Frequent Visitor

## Link Calculate Filter and Filter Control

Hello,

Can anyone point me in the direction of how to filter a DAX calculate command based on the value of the the filter control - is that even possible? I am trying to filter a table based on date.

Regards,

2 ACCEPTED SOLUTIONS

Accepted Solutions
Super User III

## Re: Link Calculate Filter and Filter Control

Hey,

I have to admit that I'm do not understand what you are requesting

If you want to pass the filterselection into your measure calculation try ALLSELECTED

https://msdn.microsoft.com/en-us/library/gg492186.aspx

If you are looking for something completely different try the search by looking for: dynamic measure

Sorry

Hamburg - Germany
I accept Kudos :-), If you find my post helpful.

Proud to be a Datanaut!
Moderator

## Re: Link Calculate Filter and Filter Control

As @TomMartens said, you just need to use ALLSELECTED() function on corresponding date column in CALCULATE() function.

Measure=CALCULATE(<expression>, ALLSELECTED(Table[Date]))

Regards,

Simon Hou

3 REPLIES 3
Super User III

## Re: Link Calculate Filter and Filter Control

Hey,

I have to admit that I'm do not understand what you are requesting

If you want to pass the filterselection into your measure calculation try ALLSELECTED

https://msdn.microsoft.com/en-us/library/gg492186.aspx

If you are looking for something completely different try the search by looking for: dynamic measure

Sorry

Hamburg - Germany
I accept Kudos :-), If you find my post helpful.

Proud to be a Datanaut!
Frequent Visitor

## Re: Link Calculate Filter and Filter Control

Hello Tom,

I want the calculate function to filter based on the control below

Thanks.

Moderator

## Re: Link Calculate Filter and Filter Control

As @TomMartens said, you just need to use ALLSELECTED() function on corresponding date column in CALCULATE() function.

Measure=CALCULATE(<expression>, ALLSELECTED(Table[Date]))

Regards,

Simon Hou

Announcements

#### New Ranks Launched March 24th!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power BI Community!

#### ‘Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

#### Arun 'Triple A' Event Video, Q&A, and Slides

Missed the Arun 'Triple A' event or want to revisit it? We've got you covered! Check out the video, Q&A, and slides now.

#### Join THE global Power Platform event series.

Attend for two days of expert-led learning and innovation on topics like AI and Analytics, powered by Dynamic Communities.

#### Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors