Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Anonymous
Not applicable

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 closed statuses based on the total?  So for example, if I want to know what % of customer's have an "open" status the answer should be 62.5% (5 open status / 8 total status).  Thank you!

 

calculation.PNG

1 ACCEPTED SOLUTION
Zubair_Muhammad
Community Champion
Community Champion

@Anonymous

 

Pls Try this

 

=
DIVIDE (
    CALCULATE ( COUNTROWS ( TableName ), TableName[Status] = "Open" ),
    COUNTROWS ( TableName )
)

Regards
Zubair

Please try my custom visuals

View solution in original post

2 REPLIES 2
Zubair_Muhammad
Community Champion
Community Champion

@Anonymous

 

Pls Try this

 

=
DIVIDE (
    CALCULATE ( COUNTROWS ( TableName ), TableName[Status] = "Open" ),
    COUNTROWS ( TableName )
)

Regards
Zubair

Please try my custom visuals
Anonymous
Not applicable

Thank you Zubair_Muhammad!

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.