Forum Discussion

poweruser55's avatar
poweruser55
Icon for Helper IV rankHelper IV
4 years ago

Count at least one flag

I have an app that calculates a few KPIS using flags.   It does this by using count of the flag. From there I need to add all of the counts together and divide by the total status count. There could ...
Need Help
bcdobbs's avatar
bcdobbs
Icon for Community Champion rankCommunity Champion
4 years ago

I think this would work better, do you want to try it with a larger dataset?

Count Example = 

VAR SelectedRows = 
    FILTER (
        'Table1',
        ( 'Table1'[SDFlag] = "Y" && 'Table1'[Status] = "active" )
        || ( 'Table1'[OtherFlag] = "Y" && 'Table1'[Status] IN { "active", "Lost" } )
        || ( 'Table1'[PFlag] = "Y" )    
    )

RETURN COUNTROWS ( SelectedRows )
poweruser55's avatar
poweruser55
Icon for Helper IV rankHelper IV
4 years ago

I also tried your way with the union but the variable doesn't come up bcdobbs