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.
Hi all,
I'm struggling with creating a measure with the sum of revenue of products on a receipt. Please see below:
For total revenue per receipt I wrote the following formula to create a calculated measure:
Solved! Go to Solution.
Hi @Anonymous , Please try:
CALCULATE(SUM(sales[revenue]),ALLEXCEPT(sales[receipt code]))
Hi @Anonymous , Please try:
CALCULATE(SUM(sales[revenue]),ALLEXCEPT(sales[receipt code]))
Thanks @Anonymous! That fixes it!
Only one small edit: ALLEXCEPT requires 2 values: first the table name then the column name. So ALLEXCEPT(sales,sales[receipt code]).
Yes, sorry. Forgot about that.
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 |
---|---|
106 | |
98 | |
75 | |
63 | |
62 |
User | Count |
---|---|
135 | |
105 | |
104 | |
80 | |
65 |