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.
When I add a new measure (in to the value field) that provides the difference between actual and plan, I'm getting two additon al column
This is how i'm calculting variance
Variance = CALCULATE(sum(PB01[Sales]),PB01[Scenario]="Actual")- CALCULATE(sum(PB01[Sales]),PB01[Scenario]="Plan")
This is what i'm getting
Customer Actual variance Plan Variance
Abc Inc 7 3 10 3
The dataset has the following colums
Customer
Sale_Amount
Scenario : Actual, Plan
Solved! Go to Solution.
Simple answer, create three measures - one for actual, one for plan, one for variance
Are you putting the scenario column on the report as well?
Yes. This is the setting for the matrix;
Row : Customers
Column: Scenario
Value: Sales
I tried to add new calculated field ( variance) to the Value and got two additional columns
Cool, you have two values for each scenario, two scenarios * two values = four columns
Here goes what I'm getting:
Customer Actual variance Plan Variance
Abc Inc 7 3 10 3
..But this what I need
Customer Actual Plan Variance
Abc Inc 7 10 3
Simple answer, create three measures - one for actual, one for plan, one for variance
Hi I have a similar problem
I am getting
Qtr1 | Qtr2
Product | total sales | variance | total sales | variance
I need
Qtr1 | Qtr2 |
Product | total sales | total sales | variance
can you help ?
Thank Austin .. Much appreciated your help
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 |
---|---|
112 | |
99 | |
73 | |
72 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |