functions used in dax
1 ) FILTER Function - The DAX FILTER function allows you to return a subset of
an expression or a table.
Syntax : FILTER(<table>,<filter>)
2 ) ALL Function - You can use the ALL function to return all of the values
in a column or all the rows in a specific table and override any filter that
was previously applied.
Syntax : ALL(<table> or <column>)
3 ) RELATED Function - This DAX function is designed to help you return a
related value from another table aside the one you’re working on.
Syntax : RELATED(<column>)
Notes : The RELATED function demands that a connection or a relationship exists
between the table you’re working on and the other table with a related data.
When you indicate the column that contains the information that you need,
the RELATED function tracks an existing relation to retrieve the value from the
indicated column in the related table.
4 ) TOTALYTD / TOTALQTD / TOTALMTD Function - The Time intelligence functions
in DAX allows users to input or change data by using various periods of time.
These include days, months, quarters, and years. This function also allows
users to build and make comparisons between calculations over such periods of
time.
Syntax : TOTALYTD(<expression>,<dates>[,<filter>][,<year_end_date>])
5 ) CALCULATE Function - The CALCULATE function is one of the most important
and multipurpose functions in DAX Power BI. This function can simplify complex
and multiple calculations with simple efforts. The DAX CALCULATE function
assesses an expression in a context that is changed by specific filters.
Syntax : CALCULATE(<expression>, <filter1>,<filter2>…)