Hello. I have these two formulas (I think for Powerpivot) The first one works fine, but the second one returns a #ref error for [Measures]. How could one work and not the other? Thanks.

1) =GETPIVOTDATA("[Measures].[Sum of Trade Cost]",$B$7)/GETPIVOTDATA("[Measures].[Distinct Count of Contract ID2]",$B$7)

2) =(GETPIVOTDATA("[Measures].[Distinct Count of ClaimID]",$B$7)*56.4)/GETPIVOTDATA("[Measures].[Distinct Count of Contract ID2]",$B$7)