Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I want to create a calculated column out of the division of a column, which is in one table, and a calculated column which is in another table.
The formula I am using is:
Column = -DIVIDE(ExpensesData[TOT Expense];SalesData[Total Revenue])
The problem arises when I type in the name of the second column (SalesData[Total Revenue]), and the error says: "A single value for column 'Total Revenue' in table 'SalesData' 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."
Solved! Go to Solution.
Probably need to use RELATED or RELATEDTABLE in your calculation.
Hi @giacomobonetti,
Is there relationship between ExpensesData and SalesData table? Just as @Greg_Deckler posted, you should use RELATED function. Could you please share the sample data or screenshot for further analysis?
Best Regards,
Angelia
Thank you both for your help. I solved the problem by creating new columns directly in the dataset, although I will keep in mind the function in case I find myself in the same situation again.
Cheers,
Giacomo
Probably need to use RELATED or RELATEDTABLE in your calculation.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
108 | |
94 | |
75 | |
63 | |
62 |
User | Count |
---|---|
143 | |
104 | |
104 | |
80 | |
66 |