calculate function

[arifulice]

The following expression give the Total salary of all month or only May ? Please help me.....

 CALCULATE([TotalSalary],FILTER(ALL(FactSalary[Month]), FactSalary[Month]="May"))

[pawel1 · Accepted solution]

May only

• CALCULATE([TotalSalary],FILTER(ALL(FactSalary[Month]), FactSalary[Month]="May"))      filters to MAY of selected year
• CALCULATE([TotalSalary],FILTER(ALL(FactSalary),              FactSalary[Month]="May"))      filters to all MAYs,  regardless of selected year

[pawel1 · Accepted solution]

May only

• CALCULATE([TotalSalary],FILTER(ALL(FactSalary[Month]), FactSalary[Month]="May"))      filters to MAY of selected year
• CALCULATE([TotalSalary],FILTER(ALL(FactSalary),              FactSalary[Month]="May"))      filters to all MAYs,  regardless of selected year

[arifulice]

Hello, pawel1

Although I have understand the problem but further you  briefly  describe the solution .(Why only  May will be the answer Although the ALL(FactSalary[Month])  remaining?

[pawel1 · Accepted solution]

Hello arifulice

I'm not an expert on DAX but I found a good explanation here:

https://community.powerbi.com/t5/Desktop/Filter-and-Allexcept/td-p/76403

the way I understand:

CALCULATE([TotalSalary],FILTER(ALL(FactSalary[Month]), FactSalary[Month]="May"))

the filter iterates only the values of the [Month] column (you will see May only).  It is the same as:

CALCULATE([TotalSalary],FactSalary[Month]="May"))

in order to remove all the filters from other columns, you change to:

CALCULATE([TotalSalary],FILTER(ALL(FactSalary), FactSalary[Month]="May"))

where the only difference is that the filter iterates the entire FactSalary table and not only the values of the Month column  (you see all months)

[arifulice]

Hello Pawel1

Thank you so  much. I have understand the solution, Thats you described in your post...