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,
I want to create a DAX that will execute a expression based on the table rows. My measure is
Thanks
Solved! Go to Solution.
Please see this post to learn more about KEEPFILTERS().
https://www.sqlbi.com/articles/using-keepfilters-in-dax/
One of the example in that article shows the syntax like below. Is that how you used it?
If this works for you, please mark it as solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
Your calculate filter on Infinity[Test] is overwriting the filter provided by the row on the table visual. Wrap it in
KEEPFILTERS() to get your desired effect.
If this works for you, please mark it as solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
This is the error I get when wrapping measure in KeepFilters
KEEPFILTERS function can only be used as a top level filter argument of CALCULATE and CALCULATETABLE or with a table argument of a function performing a table scan.
Please see this post to learn more about KEEPFILTERS().
https://www.sqlbi.com/articles/using-keepfilters-in-dax/
One of the example in that article shows the syntax like below. Is that how you used it?
If this works for you, please mark it as solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
Hi @Anonymous
try more easy
Over Spec =
CALCULATE( COUNTROWS(Infinity), Infinity[Value] > 3.6, Infinity[Test] = "Shoulder Weight")
+
CALCULATE( COUNTROWS(Infinity), Infinity[Value] > 1.4, Infinity[Test] = "Body Weight")
The result using that measure is
I need the over column to calculate based on test column
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 |
---|---|
104 | |
101 | |
79 | |
72 | |
64 |
User | Count |
---|---|
142 | |
108 | |
101 | |
81 | |
74 |