Forum Discussion

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 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

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

4 Replies

Samarth_18
Community Champion
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
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
v-henryk-mstf
Community Support
4 years ago
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.

Looking forward to your feedback.

Best Regards,
Henry
Anonymous
Not applicable
2 years ago
This POWER BI, reply in any Measure or New Column
Adults_type = 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"
)
)
)