Forum Discussion
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,
oldmanraskers
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
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
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
Hello Tom,
I want the calculate function to filter based on the control below
Thanks.
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
