Here pp and new_sales should be same.
using allexcept to summarize is giving wrong values.
Hi @Samarth-Borade ,
Do you want to calcualte the sum baed on group of three columns: grp[_Customer Code]/grp[_EDC Tradelane]/grp[_STC Tradelane]? Here I suggest you to try code as below to achieve your goal.
new_sales =
CALCULATE(SUM(grp[Rev]),ALLEXCEPT(grp,grp[_Customer Code],grp[_EDC Tradelane],grp[_STC Tradelane]))
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Table name : grp
Column: cust_name, cust_code, edc_lane, stc_lane,revenue
Slicers: cust_code,edc_lane,stc_lane
when i select cust_code in slicer : it is not summarzing up instead it is giving values for each.
code:
User | Count |
---|---|
77 | |
37 | |
34 | |
17 | |
14 |
User | Count |
---|---|
86 | |
30 | |
28 | |
17 | |
14 |