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.
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 |
---|---|
84 | |
80 | |
72 | |
71 | |
55 |
User | Count |
---|---|
108 | |
106 | |
93 | |
84 | |
66 |