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

     

     
MStark's avatar
MStark
Helper III
3 years ago

This works!! Thank you very Much!!