Need help count only fields in table with values above 0.00

[avujica]

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 !

[AlB]

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