How to calculate a measure from sum from tabl and a specific value from another table?

[Anonymous]

Hello Everyone,

Total_PR = SUM(table1[Energy2]) / SUM(table1[Irradiation]) * table2[column2].Value )

Im trying to calculate total performance based on the formula above.  so I need sum from  table 1 and a specific value from another table, but I couldnt and  I get this message "A single value for column 'park_size' in table 'park_info' cannot be determined. This can happen when a measure formula refers to a column that contains many values without specifying an aggregation such as min, max, count, or sum to get a single result."

the value should be determined by th filter/slicer that I have in the dashboard.

Thanks in advance

[Anonymous]

Hi @Anonymous 

You can use RELATED function to associate a specific value from another table .The link below you can refer to .

https://docs.microsoft.com/en-us/dax/related-function-dax

Best Regards

Community Support Team _ Ailsa Tao

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

[amitchandak]

@Anonymous , In the measure you can only use a measure or summarized columns

so the options are

Total_PR = SUM(table1[Energy2]) / SUM(table1[Irradiation]) * sum(table2[column2])

if table 2 on 1 side or relation 1-M between table1 and table2

Total_PR = SUM(table1[Energy2]) / SUMX(table1, table1[Irradiation]) * related(table2[column2]))

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.