cancel
Showing results for
Did you mean:
Frequent Visitor

## New Measure similar to SumIf

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

1 ACCEPTED SOLUTION
Super User

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/

Dashboard of My Blogs !! Connect on Linkedin
Want To Learn Power BI
Learn Power BI Beginners !! Advance Power BI Concepts !! Power BI For Tableau User !! Learn Power BI in Hindi !!
Proud to be a Super User!
!! Subscribe to my youtube Channel !!
2 REPLIES 2
Super User

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/

Dashboard of My Blogs !! Connect on Linkedin
Want To Learn Power BI
Learn Power BI Beginners !! Advance Power BI Concepts !! Power BI For Tableau User !! Learn Power BI in Hindi !!
Proud to be a Super User!
!! Subscribe to my youtube Channel !!
Frequent Visitor

Thank you!

Announcements

#### Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

#### Charticulator Design Challenge

Put your data visualization and design skills to the test! This exciting challenge is happening now through May 31st!

#### What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.