Need Count Measure

[bdehning]

I use the following measure to show days with Activity on chart and a total in a table by using Date of Service Field.    

Count Days with Service Completed Tasks = COUNTROWS(DISTINCT(isiInspections[Date Of Service]))

Date Of Service also has corresponding Activity Column of either onsite, other or remote.     

How do I create a Measure to Count the total number of "onsite" activities?

[rajendraongole1 · Accepted solution]

Hi @bdehning - can you try below measure for onsite activies

Count Onsite Days with Service Completed Tasks =
CALCULATE(
COUNTROWS(
DISTINCT(isiInspections[Date Of Service])
),
isiInspections[Activity] = "onsite"
)

Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!

[bdehning]

Ok that worked great.   Now, how do I tweak that measure to only Count number Onsite days when there was 2 or more?