Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Distinct Count based on two Columns - TRICKY

Hi Experts   How would you alter the formula as shown so    OHA_OHP = CALCULATE(COUNTROWS(Data),FILTER(Data,Data[CaseType]="Face to Face Assessment"), CONTAINSROW({"IMA HML OHP OffSite","IMA HML ...
Need Help
  • v-jiascu-msft's avatar
    v-jiascu-msft
    8 years ago

    Hi Anonymous,

     

    Try this measure please.

    OHA_OHP =
COUNTROWS (
    FILTER (
        ALL ( data[CaseType], data[WorkType] ),
        Data[CaseType] = "Face to Face Assessment"
            && data[WorkType]
            IN {
                "IMA HML OHP OffSite",
                "IMA HML OHP OnSite",
                "IMA Network OHP",
                "OHP Review 30 Minutes",
                "OHP Case Teleconference call (40 mins)" }
    )
)

    Best Regards,

    Dale

v-jiascu-msft's avatar
v-jiascu-msft
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

Hi Anonymous,

 

Try this measure please.

OHA_OHP =
COUNTROWS (
    FILTER (
        ALL ( data[CaseType], data[WorkType] ),
        Data[CaseType] = "Face to Face Assessment"
            && data[WorkType]
            IN {
                "IMA HML OHP OffSite",
                "IMA HML OHP OnSite",
                "IMA Network OHP",
                "OHP Review 30 Minutes",
                "OHP Case Teleconference call (40 mins)" }
    )
)

Best Regards,

Dale

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Hi Dale

     

    Thank you!! Thank You....this was a pain to work out understand tour approah...