Forum Discussion

Saad_Hanif456's avatar
2 years ago
Solved

undefined

Dear Experts,

When I am using the following Expression the Dax Result shows in the below table:

Calculate = Sum[Gross Salary], All[Department Name]

 

 

Slicer Year2023 
Slicer MonthJuly 
   
Department NameGross Salary Total Salary
LPG5005700
Chemicals10005700
Sales15005700
Marketing20005700
Finance7005700
Aviation 5700
LNG  5700
Lubricants  5700

 

In my data for the year (Slicer) 2023 and the month (slicer) July do not have the department names of Aviation, LNG and Lubricants still the total salary is coming the same these department as well

How can i filter the department names which is not part in that specific month

 

Desired Result

Slicer Year2023 
Slicer MonthJuly 
   
Department NameGross Salary Total Salary
LPG5005700
Chemicals10005700
Sales15005700
Marketing20005700
Finance7005700