Grid Calculation with measures

[WalidMekky]

Hi All,

I almost new to know such a thing, so you help will be apprciated.

Simply, I have some values of table,

I pick each value and get its sutable exchange rate and multiply.

My issue now just like the attached picture.

The sum of the final value after multiplication is totally wrong, as the grid get sum of value and rate column and multiply.

The right sum should be 2.28 instead of 26.97

What to do ?

Value is from the table where fx_selected_rate is a measure get the right rate and fx_value_all is another measure to multiply.

[Ashish_Mathur]

Hi,

Share the link from where i can download your PBI file.

[v-chuncz-msft · Accepted solution]

@WalidMekky,

You may try a similar way as shown here.

[WalidMekky]

Thank you,

It works perfectly.