using sql query in power bi code example
Example 1: sql query in dax power bi
EVALUATE
FILTER ( Product, Product[Color] = "Red" )
Example 2: sql query in dax power bi
SELECT *
FROM DimProduct
WHERE Color = 'Red'
EVALUATE
FILTER ( Product, Product[Color] = "Red" )
SELECT *
FROM DimProduct
WHERE Color = 'Red'