Distinct Count based on columns

[Anonymous]

Hi Experts

How would you edit the following formula to count only Distinct items nested within the containsrow function...

OHA_OHP = CALCULATE(COUNTROWS(Data),FILTER(Data,Data[CaseType]="Face to Face"), DISTINCTCOUNT(Data[WorkType]),CONTAINSROW({"IMA OHP OffSite","OHP OnSite","IMA Network OHP","OHP Review 30 Minutes", "OHP Case Teleconference call (40 mins)"},FME_Data[WorkType]))

[Anonymous]

FME_Data[WorkType])) this should be Data[WorkType])) ignore.....error on my part..

[Anonymous]

Would this work..

OHA_OHP = CALCULATE(COUNTROWS(DISTINCT(Data),Data[CaseType]="Face to Face"),,CONTAINSROW({"IMA OHP OffSite","OHP OnSite","IMA Network OHP","OHP Review 30 Minutes", "OHP Case Teleconference call (40 mins)"},Data[WorkType])) ??????

[v-yuta-msft]

Hi Route11,

Try DAX below and check if it can work.

OHA_OHP =
CALCULATE (
    DISTINCTCOUNT ( Data[WorkType] ),
    FILTER (
        Data,
        Data[CaseType] = "Face to Face"
            && CONTAINSROW (
                {
                    "IMA OHP OffSite",
                    "OHP OnSite",
                    "IMA Network OHP",
                    "OHP Review 30 Minutes",
                    "OHP Case Teleconference call (40 mins)" },
                FME_Data[WorkType]
            )
    )
)

Regards,

Jimmy Tao