Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi community,
I am doing an operation to obtain the summation of one of my fields, it must meet certain filters, but in the end it must bring me the totalized in a unique way. For example, I have my data as image 1 and I need to have the total as image 2.
Thanks for your help!
(image1)
(image2)
You can create a new table like
summarize(filter(table, table[ILE00]="MIN"),table[BWART],table[AUFNR],table[ISM00],table[ILE00])
Appreciate your Kudos.
Hi @amitchandak , thanks for your help, but the result throws me a table and I need to do the sum of a column of that summary table.
User | Count |
---|---|
126 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |