Forum Discussion

brianlehr's avatar
brianlehr
Icon for Microsoft Employee rankMicrosoft Employee
4 years ago
Solved

Percentage of rows with specific string

Easy question here (I think, as I haven't done PowerBI in a couple years and all my skills have left me):   I have a table like this Team Status Team1 Red Team1 Green Team2 Red ...
Need Help
  • ryan_mayu's avatar
    ryan_mayu
    4 years ago

    brianlehr 

    pls create a status table 

    and create a measure

    Measure = CALCULATE(COUNTROWS('Table'),'Table'[Status]=max('Table (2)'[status]))/COUNTROWS('Table')

     

ryan_mayu's avatar
ryan_mayu
Icon for Super User rankSuper User
4 years ago

brianlehr 

pls create a status table 

and create a measure

Measure = CALCULATE(COUNTROWS('Table'),'Table'[Status]=max('Table (2)'[status]))/COUNTROWS('Table')

 

  • brianlehr's avatar
    brianlehr
    Icon for Microsoft Employee rankMicrosoft Employee
    4 years ago

    This works, thank you!