Forum Discussion

himamanae's avatar
himamanae
New Member
3 years ago
Solved

How to get Pass % from the table

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

 

 

 

Show and Tell
  • ronrsnfld's avatar
    ronrsnfld
    3 years ago

    Will return all percentages , perhaps on a card?

     

     

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

     

     

     

1 Reply

  • ronrsnfld's avatar
    ronrsnfld
    Super User
    3 years ago

    Will return all percentages , perhaps on a card?

     

     

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