Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Dear Community,
I have a flat table
Column 1 | Column 2 | Column Uniq | Column Value 1 | Column Value 2 | Formula | Expected Result |
aaaa | 1111 | aaaa1111 | 100 | 12 | 100/(12+3)*12 | 80 |
aaaa | 1111 | aaaa1111 | 100 | 3 | 100/(12+3)*3 | 20 |
bbbb | 2222 | bbbb2222 | 200 | 5 | 100/5*5 | 100 |
What formula can be used to receive expected result ?
Solved! Go to Solution.
Hi @slyfox
Try this column
Column = DIVIDE ( [Column Value 1] * [Column Value 2], CALCULATE ( SUM ( TableName[Column Value 2] ), ALLEXCEPT ( TableName, TableName[Column 1] ) ) )
Hi @slyfox
Try this column
Column = DIVIDE ( [Column Value 1] * [Column Value 2], CALCULATE ( SUM ( TableName[Column Value 2] ), ALLEXCEPT ( TableName, TableName[Column 1] ) ) )
User | Count |
---|---|
98 | |
90 | |
83 | |
70 | |
67 |
User | Count |
---|---|
113 | |
104 | |
101 | |
73 | |
65 |