Help with DAX formula

[craig811]

Hi,

Please could some tell me what I am missing from the below:

=CALCULATE(VALUES(All_Data_For_Pivot[Entered CR])/All_Data_For_Pivot[Monthly Exchange Rate])

I want to / the values in All_Data_For_Pivot[Entered CR]) by the exchange rate.

I just get an error.

Thank you 

[Gordonlilj]

Hi,

You could try and use aggregation on the [Monthly Exchange Rate] such as SUM or something and see if it helps.

Otherwise could you specify what the error message says?

[craig811]

Thank you worked it out