cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Anonymous
Not applicable

## 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 Green Colour
If any single student have "Fail" status the show Green colour

 Student id Status 1 Pass 2 Fail 3 Pass 4 Pass 5 Pass
1 ACCEPTED SOLUTION
Community Champion

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

Best Regards,
Samarth

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

4 REPLIES 4
New Member
This POWER BI, reply in any Measure or New Column
IF(('all hotels'[adults] = 1 && 'all hotels'[children] = 0 && 'all hotels'[babies] = 0) ,"Single",
IF(('all hotels'[adults] = 2 && 'all hotels'[children] = 0 && 'all hotels'[babies]) = 0,"Couple",
IF(('all hotels'[adults] > 2 && 'all hotels'[children] = 0 && 'all hotels'[babies] = 0),"Group or Friends","Family"
)
)
)
Community Support

Hi @Anonymous ,

Whether the advice given by @Samarth_18  has solved your confusion, if the problem has been solved you can mark the reply for the standard answer to help the other members find it more quickly. If not, please point it out.

Best Regards,
Henry

Community Champion

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

Best Regards,
Samarth

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

Super User

@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

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.