Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I have de following matrix with 2 Orders (A and B) with 2 lines of material per line
HOW TO CREATE THE "Total of Order" COLUMN THAT HAS IN EACH LINE THE TOTAL VALUE OF THE ORDER THAT IS EQUAL TO THE SUM OF THE PARTIAL VALUES OF EACH LINE OF THE ORDER
Order lines Value Total of Order
A 1 20 30
A 2 10 30
B 1 5 20
B 2 15 20
Solved! Go to Solution.
@CR7 ,
A new column
Sumx(filter(table, [Order] = earlier([Order])),[Value])
a new measure
Sumx(filter(allselected(table), [Order] = max([Order])),[Value])
Earlier, I should have known Earlier: https://youtu.be/CVW6YwvHHi8
@CR7 ,
A new column
Sumx(filter(table, [Order] = earlier([Order])),[Value])
a new measure
Sumx(filter(allselected(table), [Order] = max([Order])),[Value])
Earlier, I should have known Earlier: https://youtu.be/CVW6YwvHHi8
THANK YOU FOR YOUR HELP
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
120 | |
101 | |
71 | |
61 |