Forum Discussion

lennox25's avatar
lennox25
Post Patron
3 years ago
Solved

Average % measure

Hi, 

How do I adapt this measure to calculate two options? I need to add Yes+ to the measure?

 

% Supported =
DIVIDE (
    CALCULATE ( COUNT ( 'Table1'[Decision Supported]), 'Table1'[Decision Supported] = "YES" ),
    CALCULATE ( COUNT ( 'Table1'[Decision Supported] ), ALLSELECTED ( 'Table1'[Decision Supported] ) )
Need Help
  • bolfri's avatar
    bolfri
    3 years ago
    % Supported =
    DIVIDE (
        CALCULATE ( COUNT ( 'Table1'[Decision Supported]), 'Table1'[Decision Supported] in {"YES","Yes+"} ),
        CALCULATE ( COUNT ( 'Table1'[Decision Supported] ), ALLSELECTED ( 'Table1'[Decision Supported] ) )

2 Replies

  • bolfri's avatar
    bolfri
    Solution Sage
    3 years ago
    % Supported =
    DIVIDE (
        CALCULATE ( COUNT ( 'Table1'[Decision Supported]), 'Table1'[Decision Supported] in {"YES","Yes+"} ),
        CALCULATE ( COUNT ( 'Table1'[Decision Supported] ), ALLSELECTED ( 'Table1'[Decision Supported] ) )