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.
I'm new to Power BI so this one would be easy I think. I'd like to show a calculation on "Total Commit" and "Total Pipeline" in our forecast. Data is organised like below
Region | Opportunity | Forecast | Stage |
AU | Opportunity 1 | $ 1,000 | COMMIT |
AU | Opportunity 2 | $ 2,000 | COMMIT |
NZ | Opportunity 3 | $ 3,000 | FUNNEL |
AU | Opportunity 4 | $ 4,000 | COVER |
NZ | Opportunity 5 | $ 5,000 | COMMIT |
NZ | Opportunity 6 | $ 6,000 | FUNNEL |
End Result
Total Commit = $8,000 (ie stage = Commit)
Total Pipeline = $21,000 (All stages)
I want to show in Matrix and Bar visual the 2 values together.
Total Commit | Total Pipleine | |
AU | $ 3,000 | $ 7,000 |
NZ | $ 5,000 | $ 14,000 |
$ 8,000 | $ 21,000 |
Please help!
Solved! Go to Solution.
@ilui ,
Have two measures like
Total Commit = calculate(sum(Table[Forecast]), stage[Stage] ="COMMIT")
Total Pipeline =calculate(sum(Table[Forecast]), stage[Stage] <> "COMMIT")
Or have new column like
Stage Type =if(stage[Stage] ="COMMIT","COMMIT","Pipeline")
you can stage Type as column or legend (in Bar).
https://www.burningsuit.co.uk/blog/2019/04/7-secrets-of-the-matrix-visual/
@ilui ,
Have two measures like
Total Commit = calculate(sum(Table[Forecast]), stage[Stage] ="COMMIT")
Total Pipeline =calculate(sum(Table[Forecast]), stage[Stage] <> "COMMIT")
Or have new column like
Stage Type =if(stage[Stage] ="COMMIT","COMMIT","Pipeline")
you can stage Type as column or legend (in Bar).
https://www.burningsuit.co.uk/blog/2019/04/7-secrets-of-the-matrix-visual/
Thank you!
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 |
---|---|
107 | |
99 | |
76 | |
64 | |
58 |
User | Count |
---|---|
148 | |
113 | |
97 | |
84 | |
67 |