Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello,
this is a massively beginner question bu I wasn't able to find a solution yet. I need to create a column, where I would have the total revenue for every customer. So it would repeat per customer. In excel it would be a simple SUMIF(Revenue, Customer=Customer in the given line).
However as a total beginner, I'm unable to recreate this as a column in Power BI.
Any help is appreciated.
Solved! Go to Solution.
You can create Calculated column or measure using below DAX code:
Category Revenue = CALCULATE(SUM(CustTable[Revenue]),ALLEXCEPT('CustTable','CustTable'[Customer]))
Calculated Column will give following output:
Measure will give following output:
Please mark my solution as Accepted if it helped you.
You can create Calculated column or measure using below DAX code:
Category Revenue = CALCULATE(SUM(CustTable[Revenue]),ALLEXCEPT('CustTable','CustTable'[Customer]))
Calculated Column will give following output:
Measure will give following output:
Please mark my solution as Accepted if it helped you.
Thank you
You're welcome
User | Count |
---|---|
92 | |
85 | |
77 | |
66 | |
62 |
User | Count |
---|---|
110 | |
95 | |
95 | |
64 | |
59 |