Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
105 | |
97 | |
75 | |
63 | |
62 |
User | Count |
---|---|
137 | |
105 | |
104 | |
80 | |
63 |