Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Calculate Column based on different Values

Hello Community,   I have a simple table showing the status of either "open" or "closed" in a column labled "status".  Is there a way to have a new column which calculates the % of open and/or clos...
Need Help
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    8 years ago

    Anonymous

     

    Pls Try this

     

    =
DIVIDE (
    CALCULATE ( COUNTROWS ( TableName ), TableName[Status] = "Open" ),
    COUNTROWS ( TableName )
)
Zubair_Muhammad's avatar
Zubair_Muhammad
Community Champion
8 years ago

Anonymous

 

Pls Try this

 

=
DIVIDE (
    CALCULATE ( COUNTROWS ( TableName ), TableName[Status] = "Open" ),
    COUNTROWS ( TableName )
)
  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Thank you Zubair_Muhammad!