cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
BRVT12
New Member

Multiply SucessRate per Country on each Person and Sum

Hello guys,

 

First post 😄

 

I'm having trouble on how to do this.

 

Context:

  • There are contracts (each one with a  price) on Continents
  • Persons have associated to them contracts
  • Success Rate to each person depends on the totalContracts / ContractsWon percentage on each continent.

I have already implemented the Success Rate

Screenshot_3.png

 

Sucess Rate Measure:

SucessRate 2 = (COUNTROWS(FILTER('Mgr/Ptr Sucess Rate'; 'Mgr/Ptr Sucess Rate'[WonOrNot] = 1))/ COUNTROWS('Mgr/Ptr Sucess Rate')) *100
 

 

Screenshot_4.png

  • First column:
    • Sum of all contracts of Person X
  • Second column:
    • What I want to do:
      • Multiply the success rate of the Person X on the Continent Y on the value of the contract that is on Continent Y
    • What I have:
      • ([SucessRate]/100) * CALCULATE(SUM('Manager Forecast'[MgrTotal]);'Manager Forecast'[Proposed] = 1)
      • (Sum all the contracts and multiply by the success rate

 

 

I'm sorry if I didn't expose the situation correctly.

2 REPLIES 2
Greg_Deckler
Super User
Super User

Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

I'm sorry, is it better?

Helpful resources

Announcements
PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Top Solution Authors
Top Kudoed Authors