dynamic calculation

[Anonymous]

Hi everyone,

I have two tables. The first one is the Target table and the second one is achievement table. The target table actually is occurring two different measures. Real currency rate and manual currency rate. When users want to measure with their own currency number, one can choose the currency and parity, and then the table is calculated by this selection. ** The image is below.

The achievement table which is the second table in the image above comes from SQL Query. 

I want to establish a connection between the two tables. The target numbers ought to compare with achievement numbers and if achievement numbers pass over the target numbers, the exceeding part should be minus from next months' target.

Every number is calculated by measure except the achievement table. 

I try to make another table to divide the target value by months. The real currency measure can be divided by months. However, the manual currency measure can not be divided by months. It returns Infınıty value, yet the currency and parity are already chosen. ** The image is below. 

My main problem is the currency and the parity selection do not count on the table above. I tried many possibilities but i can not overcome the issue. I am waiting for your solution. Thank you.

[v-xiaotang]

Hi @Anonymous 

please provide more details,

 (1) a sample file, you can replace raw data with bogus data to protect your privacy.

     or provide some sample data that fully covers your issue/question.

(2) give your expected result based on the sample you provide. Attach the calculation process please if necessary.

Kindly note: Please ensure the data in sample is concise and representative.

Thanks.

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

[MFelix]

Hi @Anonymous ,

You cannot pass values from slicer to table values, meaning that you cannot add a column to your data table that gets calculated based on the slicer selection. In this case you need to make the calculation within your measure.

Can you please share a mockup data or sample of your PBIX file and expected result. You can use a onedrive, google drive, we transfer or similar link to upload your files.

If the information is sensitive please share it trough private message.