Similar function

[Marco181]

o/ , i would like to say if in dax there is a similar function that is "where" in SQL language... Thanks everybody!

[ribisht17 · Accepted solution]

We use where to FILTER in SQL and here we use the Filter function (and you can filter even without writing the Filter function (as mentioned below rightly )as well but the moral of the story is you are filtering 🙂 )

 DAX Filter - CALCULATE function (tutorialspoint.com)

Smart Phones Sales =
CALCULATE (
SUM ( Sales[Price] ),
FILTER (
Sales,
Sales[product] in { "iPhone","Samsung","Hawaii"}
))

In SQL you would say WHERE 

[product] in { "iPhone","Samsung","Hawaii"}

Regards,

Ritesh

Mark my post as a solution if it helped you| Gentlemen & Ladies|Munde and Kudis| I like your Kudos!! !!
My You Tube Channel !! Connect on Linkedin || Power BI for Tableau Users 

[amitchandak]

@Marco181 , the filter is used to filer , in calculate you can give filter without a filter too

refer

http://dataap.org/blog/2019/04/22/difference-between-calculate-with-and-without-filter-expression/