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)

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.