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

So currently I have 9 different measure of these one for each flag. 

OLIS_Expired = CALCULATE(
DISTINCTCOUNT( '999_Funnel'[OLI Number] ),
'999_Funnel'[Expired (Flag)] = "Y",
'999_Funnel'[OLI.Status] = "Active",
'999_Funnel'[OLI.Status] = "Signed")
How can I combine the measures so they count the distinct oli in each? I tried doing Calculate(distinctcount(oli number), OLIS_Expired + ... ) but that did not work bcdobbs