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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

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
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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