Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
o/ , i would like to say if in dax there is a similar function that is "where" in SQL language... Thanks everybody!
Solved! Go to 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
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
@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/
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |