Forum Discussion

GunnerJ's avatar
GunnerJ
Icon for Post Patron rankPost Patron
4 years ago
Solved

calculate function is changing measure action

I'm needing to flag pending accounts when the value for an account's 'total as of date' is less than 1 and where the 'Action Flag' is "PENDING". 'Total as of date' returns the 'RUNNING_TOTAL' value o...
Need Help
Tutorial Requests
  • GunnerJ's avatar
    GunnerJ
    4 years ago

    This code worked. I just had to switch the action flag piece. Making it equal to a value made the measure key in on specific rows. Saying NOT "STOP" let it look at the account as a whole.

     

    Pending_Accounts = 
        CALCULATE(
            Countx(
                Filter(
                 Values('TEST CHARGES'[BI_ACCT]),
                    [total as of date] < 1 
                ) , [BI_ACCT] 
            ), 'TEST CHARGES'[ACTION_FLAG] <> "STOP"
        )

     

GunnerJ's avatar
GunnerJ
Icon for Post Patron rankPost Patron
4 years ago

This code worked. I just had to switch the action flag piece. Making it equal to a value made the measure key in on specific rows. Saying NOT "STOP" let it look at the account as a whole.

 

Pending_Accounts = 
        CALCULATE(
            Countx(
                Filter(
                 Values('TEST CHARGES'[BI_ACCT]),
                    [total as of date] < 1 
                ) , [BI_ACCT] 
            ), 'TEST CHARGES'[ACTION_FLAG] <> "STOP"
        )