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.
How do i seperate the far right column to show the sum per order # instead of the total for both? All of the values in "Column" for Order# 10001 should be 10 and 10002 should be 12.
Solved! Go to Solution.
Try this :
Column = CALCULATE(SUM(Table1[Revenue]),ALL(Table1), Table1[Order#]= EARLIER(Table1[Order#]), Table1[Item Version]="S")
Thanks
Raj
What about
Column =
CALCULATE (
SUM ( Sheet2[Per Item Revenue] ),
FILTER (
ALL ( Sheet2 ),
Sheet2[Item Version] = "s"
&& Sheet2[Order #] = SELECTEDVALUE ( Sheet2[Order #] )
)
)
Thanks, unfortunately that just returned all blanks.
What about this?
Column = CALCULATE ( SUM ( Sheet2[Per Item Revenue] ), FILTER ( ALL ( Sheet2 ), Sheet2[Item Version] = "s" && EARLIER ( Sheet2[Order #] ) ) )
If that doesn't work, try removing the ALL function:
Column = CALCULATE ( SUM ( Sheet2[Per Item Revenue] ), FILTER ( Sheet2, Sheet2[Item Version] = "s" && EARLIER ( Sheet2[Order #] ) ) )
That's what I had. 😕
Ok, try removing the ALL function. I had an alternate formula in my last post (I added it as an edit), see if that works.
Still getting the total revenue for all "s" revenue instead of it sorting by Order #.
Try this :
Column = CALCULATE(SUM(Table1[Revenue]),ALL(Table1), Table1[Order#]= EARLIER(Table1[Order#]), Table1[Item Version]="S")
Thanks
Raj
Awesome, thanks!
Got it (I think):
Column = CALCULATE ( SUM ( Sheet2[Per Item Revenue] ), FILTER ( Sheet2, Sheet2[Order #] = EARLIER ( Sheet2[Order #] ) && Sheet2[Item Version] = "S" ) )
Good job @Anonymous , Your logic was right, just syntax needed some correction.
Thanks
Raj
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 | |
94 | |
76 | |
62 | |
50 |
User | Count |
---|---|
147 | |
106 | |
104 | |
87 | |
61 |