Forum Discussion
Anonymous
2 years agoNot applicable
Budget Variance
Hello, I am still fairly new to PBI. I am creating visuals for Budget Variances. I am given the Actuals and the Budget in the data set. I created a measure to do so: OL6 Variance = DIVIDE(SU...
Anonymous
2 years agoNot applicable
Hi this helps. However, moreso if the budget is 0 and there is an amount in the actuals how would I get the outcome to show 100% instead of 0%?
gmsamborn
2 years agoSuper User
Hi Anonymous
In the above measure, change "No Budget" to 1.