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 ...
Hi SHAKEDALROY ,
You could leran the merge from this link.
After you merged, try this measure.
CALCULATE(SUM('Table'[IssuingAgencyAverageYearlySalary]),FILTER('TABLE',YEAR([IssueDate]) = 2016))*0.03
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.