Custom Card with Color Coding - Customer Payment Rating

[XeperRx]

Hello All, 

I'm really starting to feel comfortable with all of the basic functionallity of PBI, but have just started getting my feet wet with DAX, any help would be greatly appreciated. 

I would like to create a custom card that will provide a rating based on customer payment history. I have a column in my data set named Payment Status that defines if invoices were either Late, On-Time, or Open - 

I would like the card to read as follows based off of the Payment Status Column - 

# of Late Payments = 0, Excellent/Green 

# of Late Payments = 1-5, Fair/Yellow

# of Late Payments = 6>, Poor/Red
 

[Greg_Deckler · Accepted solution]

Maybe:

Measure =
  VAR __Count = COUNTROWS(FILTER('Table',[Payment Status] = "Late"))
RETURN
  SWITCH(TRUE(),
    __Count < 1,"Excellent/Green",
    __Count > 5,"Poor/Red",
    "Fair/Yellow"
  )