How to get Grand Total on Measure Table

[PBI_newuser]

Hi,

The Grand Total of each row in the measure table  is incorrect.

How can I fix it? Sample here.

[amitchandak]

@PBI_newuser , Try calculations like

Values for Matrix = 
VAR Calc = 
IF(SELECTEDVALUE('Measure'[ID])=1,FORMAT([Current Hours],"#,0"),
IF(SELECTEDVALUE('Measure'[ID])=2,FORMAT([Available Hours],"#,0"),
IF(SELECTEDVALUE('Measure'[ID])=3,FORMAT([Diff (Hours)],"#,0"),
IF(SELECTEDVALUE('Measure'[ID])=4,FORMAT([Current Technician],"#0"),
IF(SELECTEDVALUE('Measure'[ID])=5,FORMAT('Available Technician'[Available Technician],"#0"),
FORMAT([Diff (Technician)],"#0"))))))
VAR Calc1 = 
sumx(VALUES('Measure'[Measure]),CALCULATE(IF(SELECTEDVALUE('Measure'[ID])=1,[Current Hours],
IF(SELECTEDVALUE('Measure'[ID])=2,[Available Hours],
IF(SELECTEDVALUE('Measure'[ID])=3,[Diff (Hours)],
IF(SELECTEDVALUE('Measure'[ID])=4,[Current Technician],
IF(SELECTEDVALUE('Measure'[ID])=5,'Available Technician'[Available Technician],
[Diff (Technician)])))))))
return
if(ISINSCOPE('Measure'[Measure]),Calc,Calc1)

[PBI_newuser]

Hi @amitchandak, it doesn't work.

Do you mind to share your pbix file for the above calculations?

[amitchandak]

@PBI_newuser , attached after signature

[PBI_newuser]

Hi @amitchandak , thanks for the file.

The Total highlighted in red is still incorrect. 

E.g.

Total for Available Hours should be 1720 instead of 860.

Total for Current Technician should be 34 instead of 13.