Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Dax calculation help

Hello,    I need somehelp on Dax calulation. Below is the sample data:   I have dataset like below.  Department Grade No of Emp IT A 90 IT B 90 IT C 90 HR A 10 HR B ...
Need Help
  • PattemManohar's avatar
    PattemManohar
    7 years ago

    Anonymous  In that case, create a new measure as below

     

    Test288 = 
VAR _IT = MAXX(FILTER(Test288SumIF,Test288SumIF[Department]="IT"),Test288SumIF[NoOfEmp])
VAR _Other = SUMX(Test288SumIF,Test288SumIF[NoOfEmp])
RETURN IF(SELECTEDVALUE(Test288SumIF[Department])="IT",_IT,_Other)

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi PattemManohar ,

 

Thank you its working but the other thing I would like to add is I want to show 'Department' and 'Grade' as slicers. So when the user select Department = IT and Grade = All then it should show 90 and even if the user select a particular grade lets say 'A' and department = IT it should show 90 only. Any chance its possible please? 

 

Many Thanks

PattemManohar's avatar
PattemManohar
Community Champion
7 years ago

Anonymous  In that case, create a new measure as below

 

Test288 = 
VAR _IT = MAXX(FILTER(Test288SumIF,Test288SumIF[Department]="IT"),Test288SumIF[NoOfEmp])
VAR _Other = SUMX(Test288SumIF,Test288SumIF[NoOfEmp])
RETURN IF(SELECTEDVALUE(Test288SumIF[Department])="IT",_IT,_Other)

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Thanks alot PattemManohar . Its working perfectly.