Forum Discussion

XeperRx's avatar
XeperRx
Frequent Visitor
6 years ago
Solved

Custom Card with Color Coding - Customer Payment Rating

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 ...
  • Greg_Deckler's avatar
    Greg_Deckler
    6 years ago

    Maybe:

     

    Measure =
  VAR __Count = COUNTROWS(FILTER('Table',[Payment Status] = "Late"))
RETURN
  SWITCH(TRUE(),
    __Count < 1,"Excellent/Green",
    __Count > 5,"Poor/Red",
    "Fair/Yellow"
  )
Greg_Deckler's avatar
Greg_Deckler
Community Champion
6 years ago

Maybe:

 

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