Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

if

i have two columns "Student ID" & "Status" in database, need a calculation to show colour on a card(Overall status) based on below conditions   Condition: IF all student have "Pass" status the show...
Need Help
  • Samarth_18's avatar
    Samarth_18
    4 years ago

    Hi Anonymous 

    Create a measure like below for overall status:-

    Measure 3 = if(COUNTROWS(FILTER('Table (3)','Table (3)'[Status] = "Fail"))>0,"Fail","Pass")

    Now create a measure with below code and use it in conditional formatting:-

     

    Measure =
IF (
    COUNTROWS ( FILTER ( 'Table (3)', 'Table (3)'[Status] = "Fail" ) ) > 0,
    "Red",
    "Green"
)

     

    Output:-

     

     

     

    Thanks,

    Samarth

amitchandak's avatar
amitchandak
Super User
4 years ago

Anonymous ,

New measure =

var _color = countrows(filter(Allselected(Table), Table[Status] = "Fail"))

return

if(isblank(_color) , "Green", "Red")

 

Use this measure in conditional formatting using field value option