Measure to Flag Fees on Accounts

[Alta88]

Our accounts sometimes require a specific fee based on the city, state, and county in which they're located. I want to create a flag to show which accounts were not charged the applicable fee.

For example: an account in Las Vegas, NV, in the County of Clark, will have a fee of $7. Any accounts where this is fee isn't charged will need to be flagged.

[Alta88]

Follow up: could I use this same measure's syntax to flag for the following? Our accounts that list a bank account (Checking, Savings, etc.) need to then have an ACH indicator checked for proper billing. 

I need to flag which accounts have an actual bank account (Bank Acct Type) and whether or not the ACH indicator is checked.  If it's not checked and there is a bank account, we would flag for an error: 

[Alta88]

Yes, thanks for this! Greatly appreciated!

[v-yinliw-msft · Accepted solution]

Hi @Alta88 ,

You can try this method:

New a measure:

Color =
SWITCH (
    TRUE (),
    MAX ( 'Table'[City] ) = "Las Vegas"
        && MAX ( 'Table'[State] ) = "NV"
        && MAX ( 'Table'[County] ) = "Clark"
        && MIN ( 'Table'[Fee] ) <> 7, "Red"
)

And set a conditional format to the Fee column:

Then the result is:

Hope this helps you.

Here is my PBIX file.

Best Regards,

Community Support Team _Yinliw

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.