Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to 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
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
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
User | Count |
---|---|
98 | |
90 | |
82 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
67 |