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'm having a bit of a struggle with this.
I have one data set that contains productID and product unit price and another data set that contains productID and unit cost. I have them related so that I can see the product ID, unit price and unit cost in the report, but I want to create another (measured?) column for unit profit. this is what I'm trying:
Measure = SUM(ALLdata[Unit Price]-('display-cost-feb2016'[Cost]))
But it tells me the SUM function only accepts a column reference as an argument. Unit Price and Cost are both column names, just on 2 different data sets. What am I doing wrong?
thanks!
Solved! Go to Solution.
Your syntax has to be changed to
Measure = sum(Table1[column1]) - sum(Table2[column2])
Can you try this and let me know if it is ok?
Your syntax has to be changed to
Measure = sum(Table1[column1]) - sum(Table2[column2])
Can you try this and let me know if it is ok?
I'm trying to do something similar to this but I'm calculating a share percentage so I'm dividing the two numbers (ex. sum(Table1[column1]) / sum(Table2[column2]). The problem I'm having is that the value from table 2 seems to have lost any reference it had to the year because my numbers are way off because it is using the grand total of the column 2 value for the division instead of just using the portion that belongs to a single year (see below).
The _ITAVolume number for 2011 should be around 158,000.
Any assistance with this would be greatly appreciated.
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 |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
93 | |
84 | |
66 |