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.
Hi Guys,
Wondering if someone can help me with a measure and teh syntax that would show the total count of "test counts" that have a "total estimated lab hours (test)" of greater than 0.00. In this example my "test count" says 36 but I only have 10 with a value of greater than 0.00.
thank you all for your help as I am new to writing measures but your help has been amazing and everytime you guys help I learn something new...thanks !
Hi @avujica
Measure =
CALCULATE (COUNT(Table1[Test Counts]), Table1[total estimated lab hours (test)] > 0 )
Please mark the question solved when done and consider giving a thumbs up if posts are helpful.
Contact me privately for support with any larger-scale BI needs, tutoring, etc.
Cheers
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 |
---|---|
47 | |
26 | |
19 | |
14 | |
10 |
User | Count |
---|---|
57 | |
49 | |
44 | |
18 | |
18 |