Showing results for 
Search instead for 
Did you mean: 
New Member

Multiply SucessRate per Country on each Person and Sum

Hello guys,


First post 😄


I'm having trouble on how to do this.



  • 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



Sucess Rate Measure:

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



  • 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.

Super User
Super User

Please see this post regarding How to Get Your Question Answered Quickly:

@ 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

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