Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi everyone! how I can sum PRODSERIE without dublication(for SERIE). Me need get result: SERIE-1(100) + SERIE-2(300)+SERIE-3(300)=700 for Type=0 and SERIE-4(300)=300 for Type 1;
ID | SERIE | PRODSERIE | TYPE | ANOTHER VALUE |
1 | 1 | 100 | 0 | 1 |
2 | 1 | 100 | 0 | 50 |
3 | 2 | 300 | 0 | 23 |
4 | 2 | 300 | 0 | 254 |
5 | 2 | 300 | 0 | 234523 |
6 | 3 | 300 | 0 | 400 |
7 | 4 | 300 | 1 | 1545 |
8 | 4 | 300 | 1 | 345345 |
Solved! Go to Solution.
Try like
sumx(summarize(table,table[SERIE], "_1",maxX(filter(Table, (Table[TYPE]=0 && table[SERIE]<=3) ||
(Table[TYPE]=1 && table[SERIE]=4)) Table[PRODSERIE])),[_1])
Try like
sumx(summarize(table,table[SERIE], "_1",maxX(filter(Table, (Table[TYPE]=0 && table[SERIE]<=3) ||
(Table[TYPE]=1 && table[SERIE]=4)) Table[PRODSERIE])),[_1])
Try using SUMMARIZE like:
Measure =
SUMX(
SUMMARIZE('Table',[SERIE],"__Value",AVERAGE([PRODSERIE])),
[__Value]
)
User | Count |
---|---|
86 | |
82 | |
68 | |
64 | |
55 |
User | Count |
---|---|
123 | |
100 | |
90 | |
83 | |
66 |