topic Need Count Measure in DAX Commands and Tips

Need Count Measure

bdehning — Tue, 25 Jun 2024 03:30:40 GMT

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?

Re: Need Count Measure

rajendraongole1 — Tue, 25 Jun 2024 04:08:07 GMT

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!!

Re: Need Count Measure

bdehning — Tue, 25 Jun 2024 04:17:59 GMT

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