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 have a measure that i want to use based on summing up the category
for example
flat type cost expected result
100 20 50
100 30 50
200 40 90
200 50 90
300 60 60
i have hit a total blank this morning, if i want to sum the cost by flat type and store that in a separte column for each row, how do i do this?
Proud to be a Super User!
Solved! Go to Solution.
HI @vanessafvg,
Based on my understanding, you want to summary the total cost of the same type, right?
If this is a case, you can refer to below formula:
Calculate column:
Result = SUMX(FILTER(ALL('sample 2'),[flat type]=EARLIER('sample 2'[flat type])),[cost])
Measure:
Result = SUMX(FILTER(ALL('sample 2'),[flat type]=MAX('sample 2'[flat type])),[cost])
Regards,
Xiaoxin Sheng
anyone 🙂
Proud to be a Super User!
HI @vanessafvg,
Based on my understanding, you want to summary the total cost of the same type, right?
If this is a case, you can refer to below formula:
Calculate column:
Result = SUMX(FILTER(ALL('sample 2'),[flat type]=EARLIER('sample 2'[flat type])),[cost])
Measure:
Result = SUMX(FILTER(ALL('sample 2'),[flat type]=MAX('sample 2'[flat type])),[cost])
Regards,
Xiaoxin Sheng
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 | |
98 | |
78 | |
65 | |
60 |
User | Count |
---|---|
148 | |
113 | |
97 | |
84 | |
67 |