Forum Discussion
Creating a Measure
Hi, I made a calculationg in SQL.. and i need to convert it to a measure in Power BI. In my SQL i have 3 tables (FactParkingViolation,DimIssuer,DimIssuingAgency), when i added the the tables to ...
i think something is still missing @AllisonKennedy /:
The result in SQL is 18,639,996
and when i tried your formula in Power BI the result is 451,796,281
How have you done the merge? Did you remove duplicates, your SQL code uses DISTINCT, which we haven't accounted for in the DAX. Also, it's possible to increase rows in merge if you're not careful. https://excelwithallison.blogspot.com/2020/10/merge-ahead-one-for-one.html