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 service. This DAX logic has performed in other contexts. The end result is a COUNTROWS of a table of any authorizations that meet the conditions. This will eventually become binary (1/0) but there is a problem with multiple overlapping authorizations, which the COUNTROWS should help track down.
For one case in question, the result of the calculated column is 5, indicating that there are 5 overlapping authorizations during the service date. But when I create a calculated table to see what is in the count, it only shows 1 row.
Any insights into this? Is there something in my DAX that is causing this?
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!