Forum Discussion
Solved
COUNTROWS Returning Wrong Value
I have a calculated column called Service Authorized in the FACT-Services table. Its intention is to make sure there is an authorization in place (FACT-BH Authorizations table) for the date of servic...
Ultimately, there was a problem with the relationships that was fixed. However, your solution also works. Thank you.
Hello there jguercio ! Have you tried with a Summarize?
Service Authorized =
VAR AuthTable =
SUMMARIZE(
FILTER(
'FACT-BH Authorizations' ,
'FACT-Service'[Client ID] = 'FACT-BH Authorizations'[Client ID]
&& 'FACT-Service'[Contact Date] >= 'FACT-BH Authorizations'[AuthStart]
&& 'FACT-Service'[Contact Date] <= 'FACT-BH Authorizations'[AuthEnd]
&& IF(
'FACT-Service'[Program ID] = "30001013",
'FACT-BH Authorizations'[UCode] = "U749",
IF(
'FACT-Service'[Program ID] = "30001075",
'FACT-BH Authorizations'[UCode] = "U649",
IF(
OR( 'FACT-Service'[Program ID] = "30001014", 'FACT-Service'[Program ID] = "30001015" ),
'FACT-BH Authorizations'[UCode] = "U349",
IF(
'FACT-Service'[Program ID] = "30001005",
'FACT-BH Authorizations'[UCode] = "U749"
|| 'FACT-BH Authorizations'[UCode] = "U649"
|| 'FACT-BH Authorizations'[UCode] = "U349"
)
)
)
)
),
'FACT-Service'[Client ID], #for example
"Rows", 1
)
RETURN
SUM( [Rows] )Hope this answer solves your problem!
If you need any additional help please @ me in your reply.
If my reply provided you with a solution, please consider marking it as a solution ✔️ or giving it a kudoe 👍
Thanks!
You can also check out my LinkedIn!
Best regards,
Gonçalo Geraldes
Ultimately, there was a problem with the relationships that was fixed. However, your solution also works. Thank you.