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.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
97 | |
96 | |
81 | |
74 | |
66 |
User | Count |
---|---|
126 | |
106 | |
105 | |
86 | |
72 |