Power BI Video: How To Use Power BI Calculate Function
Power BI Video: How To Use Power BI Calculate Function
CALCULATE function is the often used DAX function in Power BI.
Even though CALCULATE function cannot do anything, it works as a base function to apply other DAX functions in different scenarios.
For example, suppose you want to apply a filter and find the total sales or revenue for one particular region.
In that case, we can use the CALCULATE function to apply the filter and arrive at calculations.
So, the CALCULATE function evaluates the expression given by the user with all the applied filters.
Below is the syntax of the CALCULATE function.
Expression: This is nothing but what is the expression we need to perform. For example, if we need to get the sales total.
Filter 1: Based on the Expression given, what is the filter we need to apply. For example, to get the Expression result, Filter 1 will be anyone particular region.
Filter 2: Based on the Expression given, what is the second set of filters, we need to apply, for example, in the particular region particular PIN Code region.
For example, assume you need to create a “New Measure,” which gives one particular city total, for example, “NE"
The steps to use the DAX calculate function in Power BI is as follows.
1. Right-click on the table, and choose the “New measure” option
2. Give the name to this measure “REVENUE FOR NE”
3. Now, open the CALCULATE function
4. An expression is the first option. We need to add the “NE ” region total in this example, so open the SUM function.
5. The “ColumnName” we need to SUM is the “REVENUE” column, so choose the respective column.
6. The table we refer to is the “Sales Data.” So first, choose the table name.
7. We need to select the “region” column for FilterExpression and give the criteria as “NE”
8. We are done. Close two brackets and press the “Enter” key to get the new measure.
9. Drag the “Columbia City Sales” to “Fields” to see the new measure.
10. Now, this measure only gives the total revenue of the region “NE”
Is the video helpful?
Drop your comment
Do you want to learn Data Analytics Using Excel, Power BI and SQL?
Join our January Cohort at Lead-Leap Data Analytics School
It is 5 weeks program(weekend classes).
We run both physical and online classes
The training starts on Saturday 14th of January, 2022
Call us on 08062468296 or visit www.leadleapconsult.com to register
Choose Lead-Leap Data Analytics School
Смотрите видео Power BI Video: How To Use Power BI Calculate Function онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь Akerele Oluwasogo (Mr Excel) 01 Январь 1970, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 103 раз и оно понравилось 2 людям.