Forum Discussion
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 OHP OnSite","IMA Network OHP","OHP Review 30 Minutes", "OHP Case Teleconference call (40 mins)"},Data[WorkType]))
So When CaseType Column is filter for Face to Face Assessment criteria and then we look at the work type column (here i need to count only distinct Values) as shown....
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
2 Replies
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