New Measure similar to SumIf

[ilui]

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!

[amitchandak · Accepted 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]

Thank you!