Forum Discussion
Similar function
o/ , i would like to say if in dax there is a similar function that is "where" in SQL language... Thanks everybody!
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
2 Replies
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/
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
