Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
in table column C i need to get SUM so Instead of 36.31 i need to get 72.52
| A | B | C | c formula |
| 30,548.0 | 847 | 36.08 | a/b |
| 57,953.0 | 1,590.0 | 36.44 | |
| 88,501.0 | 2,437.0 | 36.31 |
Solved! Go to Solution.
@AhmedIssa
Use the following measure:
per = SUMX ( VALUES(Table1) , DIVIDE ( Table1[a], Table1[b] ))
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
@AhmedIssa
Can try this? Please adjust the formula as per your table and column names;
MeasureC =
IF (
ISFILTERED (TableName[ColumnName]),
DIVIDE (
SUM( TableName[Column A] ),
SUM( TableName[Column B] )
),
SUMX (
TableName ,
DIVIDE (
SUM( TableName[Column A] ) ,
SUM( TableName[Column B] )
)
)
)
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
kindly check simple file
https://u.pcloud.link/publink/show?code=XZmy7EXZNIL45anzggJ3OD5Q21EK0us3ryKV
@AhmedIssa
Use the following measure:
per = SUMX ( VALUES(Table1) , DIVIDE ( Table1[a], Table1[b] ))
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!