Forum Discussion
Return Count of Rows Where Key Not Referenced
I am trying to return the count of rows from TableA that are not referenced in TableB, so for my raw SQL I setup the following query: SELECT TableA.Id, TableB.TableAId
FROM TableA
LEFT OUTER JOIN Ta...
Hi dday9 ,
If you wish this could be done without the need to create a new measure or new table, recommend you post your issue in SQL Server Community forum for further professional help .
Best Regards,
Amy
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thank you Amy, but just to clarify I do have a working SQL solution and ultimately I wound up going with running a CTE when importing my data rather than using a Measure. My issue revolved around achieving the same thing, only using a pure Power BI solution.