Forum Discussion
Need Count Measure
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?
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!!
2 Replies
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!!Ok that worked great. Now, how do I tweak that measure to only Count number Onsite days when there was 2 or more?
