Forum Discussion

bdehning's avatar
bdehning
Post Prodigy
2 years ago
Solved

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(isiInspecti...
Need Help
Show and Tell
  • rajendraongole1's avatar
    rajendraongole1
    2 years ago

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

rajendraongole1's avatar
rajendraongole1
Super User
2 years ago

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's avatar
bdehning
Post Prodigy
2 years ago

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