Forum Discussion

MStark's avatar
MStark
Helper III
3 years ago
Solved

Row Percentages

Im trying to get the % of potential customers by Item and my measure is only giving it by department. How can I get it for each Row? This is what Im looking for in Excel: In Power BI only get...
Need Help
  • vojtechsima's avatar
    vojtechsima
    3 years ago

    MStark 
    It should be rather 81.50, if you want to be precise:

    Measure = 

var Potential = CALCULATE(SUMX(FILTER('Table', 'Table'[Department name] = "Potential"), 'Table'[Amount]), ALL('Table'[Department name], 'Table'[Account title]))
var TheRest = SUM('Table'[Amount])
var check = DIVIDE(TheRest, Potential)
return check

     

     
vojtechsima's avatar
vojtechsima
Super User
3 years ago

MStark 
You're using a different formula than I do tho.
Please give me data in text form so I can play with them in my environment, please.

 
MStark's avatar
MStark
Helper III
3 years ago

 

Location IDDepartment nameAccount titleEntry dateAmount
101Customers1on15/31/202231.00
101Customers1on16/30/202230.00
101Customers1on17/31/202231.00
101CustomersConsulting5/31/2022170.00
101CustomersConsulting6/30/2022292.00
101CustomersConsulting7/31/2022188.00
101CustomersCorp5/31/2022282.00
101CustomersCorp6/30/2022317.00
101CustomersCorp7/31/2022270.00
101CustomersOnline5/31/2022312.00
101CustomersOnline6/30/2022261.00
101CustomersOnline7/31/2022369.00
101CustomersOnsite7/31/2022132.00
101CustomersTraining5/31/202220.00
101CustomersTraining6/30/202299.00
101PotentialPossible costomers5/31/20221,000.00
101PotentialPossible costomers6/30/20221,000.00
101PotentialPossible costomers7/31/20221,000.00
101Revenue1on15/31/20221,200.00
101Revenue1on16/30/2022156.00
101Revenue1on17/31/2022165.00
101RevenueConsulting5/31/202219,999.00
101RevenueConsulting6/30/202256,555.00
101RevenueConsulting7/31/202246,468.00
101RevenueCorp5/31/20225,555.00
101RevenueCorp6/30/202255,556.00
101RevenueCorp7/31/202255,555.00
101RevenueOnline5/31/2022#########
101RevenueOnline6/30/2022#########
101RevenueOnline7/31/2022#########
101RevenueOnsite7/31/202265,000.00
101RevenueTraining5/31/2022#########
101RevenueTraining6/30/2022#########
101RevenueTraining6/30/2022#########

 

Thanks!!

  • vojtechsima's avatar
    vojtechsima
    Super User
    3 years ago

    MStark 
    It should be rather 81.50, if you want to be precise:

    Measure = 

var Potential = CALCULATE(SUMX(FILTER('Table', 'Table'[Department name] = "Potential"), 'Table'[Amount]), ALL('Table'[Department name], 'Table'[Account title]))
var TheRest = SUM('Table'[Amount])
var check = DIVIDE(TheRest, Potential)
return check

     

     
    • MStark's avatar
      MStark
      Helper III
      3 years ago

      This works!! Thank you very Much!!