Click on SQL endpoint on the Costoso Lakehouse
Click on SQL endpoint on the Costoso Lakehouse
Click on the table OnlineSales and New Measure
Open the Power BI Desktop or PBI in fabric and Get Data from that SQL endpoint which will surface the new measure
Click on New Visual Query
Drag Product and Online Sales
Click on Merge Queries
Select Product Key in both table and select inner join
Click OK
Select the table product-> Reduce Rows-> Filter Rows
Put the filter condition
Generates the report as below