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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
himamanae
New Member

How to get Pass % from the table

I need to get the Pass % and Execution %, how to create new measure for this?

 

 

himamanae_0-1685895907500.png

 

1 ACCEPTED SOLUTION
ronrsnfld
Super User
Super User

Will return all percentages , perhaps on a card?

 

ronrsnfld_0-1685926825567.png

 

% Total = 
VAR _A =
    CALCULATE(
        COUNTA('Table'[Status])
    )
VAR _B =
    CALCULATE(COUNTA( 'Table'[Status] ), ALL( 'Table' ) )
RETURN
    _A / _B

ronrsnfld_1-1685926914629.png

 

 

 

View solution in original post

1 REPLY 1
ronrsnfld
Super User
Super User

Will return all percentages , perhaps on a card?

 

ronrsnfld_0-1685926825567.png

 

% Total = 
VAR _A =
    CALCULATE(
        COUNTA('Table'[Status])
    )
VAR _B =
    CALCULATE(COUNTA( 'Table'[Status] ), ALL( 'Table' ) )
RETURN
    _A / _B

ronrsnfld_1-1685926914629.png

 

 

 

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

July Newsletter

Fabric Community Update - July 2024

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

Top Solution Authors
Top Kudoed Authors