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

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
DairyG1
Helper I
Helper I

Create measure based on calculated status column

Hello All,

 

Hope i can get your expert help.

 

I have a calculated column with two statuses - Pass & Fail

I want to show the percentage of Pass items within a card.

 

Can someone guide me on this please?

 

Thank you

1 ACCEPTED SOLUTION
PijushRoy
Super User
Super User

Hi @DairyG1 

Please use 

Pass% = Divide(
Calculate(Count(PassFailCouln),PassFailCouln="Pass"),
Count(PassFailCouln))

 

Change the datatype of the measure as Percentage




Did I answer your question? Mark my post as a solution!
Appreciate your Like/Kudos

Proud to be a Super User!





View solution in original post

4 REPLIES 4
PijushRoy
Super User
Super User

Hi @DairyG1 

Please use 

Pass% = Divide(
Calculate(Count(PassFailCouln),PassFailCouln="Pass"),
Count(PassFailCouln))

 

Change the datatype of the measure as Percentage




Did I answer your question? Mark my post as a solution!
Appreciate your Like/Kudos

Proud to be a Super User!





@PijushRoy - Thank you that worked great, much appreciated for the support

Idrissshatila
Super User
Super User

Hello @DairyG1 ,

 

so what you can do is count all the rows and count rows with specific statuse and then divide the counted rows with each status with the all rows.

 

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin



Did I answer your question? Mark my post as a solution! Appreciate your Kudos
Follow me on LinkedIn linkedIn
Vote for my Community Mobile App Idea

Proud to be a Super User!




@Idrissshatila - thanks but can you elborate on how that would be written please

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

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

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

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