Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello Power BI Experts,
How can I display total % variance in a table. Left screenshot is my imported data. Thanks for the help!
Solved! Go to Solution.
Hi @mason23 ,
To update the formula as below.
Measure = DIVIDE(SUM(Table1[variance]),SUM(Table1[total budget]))
Pbix as attached.
Hi @mason23 ,
Enable the sum option for the column.
Or we can create a measure to work on it.
Measure = SUM(Table1[variance %])
Thank you for the reply. What I'm looking for is the individual row percentage. The variance % column is computed from a calculated column formula . = Variance / Total Budget. The missing Variance % is the total($2,840,340.46 / $3,909,323) This should give me 73%
with right click on selected Variance field and click on Show value > as a percent of column total
Hi @mason23 ,
To update the formula as below.
Measure = DIVIDE(SUM(Table1[variance]),SUM(Table1[total budget]))
Pbix as attached.
Thank you! That works!
User | Count |
---|---|
96 | |
87 | |
78 | |
72 | |
68 |
User | Count |
---|---|
113 | |
105 | |
84 | |
65 | |
64 |