Link Calculate Filter and Filter Control

[oldmanraskers]

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,

oldmanraskers

[TomMartens · Accepted solution]

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

[TomMartens · Accepted solution]

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

[oldmanraskers]

Hello Tom,

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

Thanks.

[v-sihou-msft · Accepted solution]

@oldmanraskers

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