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 need to filter this formula:
.Media = SUM (Tips [Odd]) / COUNT (Tips [Odd]) //Current formula
I need to filter only if it is greater than or equal to 4 (Tips [Odd])
I do not know how to make this condition, if anyone can help me.
Thank you.
Solved! Go to Solution.
Hi @strikw,
Try with this:
NewMeasure = CALCULATE ( [Media]; Tips[Odd] > 4 )
Or in the same measure:
Media = CALCULATE ( SUM ( Tips[Odd] ) / COUNT ( Tips[Odd] ); Tips[Odd] > 4 )
Regards.
Note: If you get a syntax error it's probably because of the semicolons instead of commas, Power BI has the two options to delimit DAX, change semicolons by commas and it should work.
Proud to be a Super User!
Hi @strikw,
Try with this:
NewMeasure = CALCULATE ( [Media]; Tips[Odd] > 4 )
Or in the same measure:
Media = CALCULATE ( SUM ( Tips[Odd] ) / COUNT ( Tips[Odd] ); Tips[Odd] > 4 )
Regards.
Note: If you get a syntax error it's probably because of the semicolons instead of commas, Power BI has the two options to delimit DAX, change semicolons by commas and it should work.
Thank you very much, it worked well.
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 |
---|---|
112 | |
97 | |
84 | |
67 | |
60 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |