Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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....
Solved! Go to Solution.
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
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
Hi Dale
Thank you!! Thank You....this was a pain to work out understand tour approah...
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
81 | |
66 | |
58 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |