Forum Discussion
WalidMekky
8 years agoFrequent Visitor
Grid Calculation with measures
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.
3 Replies
- v-chuncz-msftCommunity Support
- WalidMekkyFrequent Visitor
Thank you,
It works perfectly.
- Ashish_MathurSuper User
Hi,
Share the link from where i can download your PBI file.