Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

October 28 & 29: Experts share their secrets on how to pass the Fabric Analytics Engineer certification exam—live. Learn more

Reply
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
1Pass
2Fail
3Pass
4Pass
5Pass
1 ACCEPTED SOLUTION
Samarth_18
Community Champion
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:-

Samarth_18_0-1644224152521.png

 

 

 

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.
Appreciate your Kudos!!
Connect on Linkedin

View solution in original post

4 REPLIES 4
Ankit89301
New Member

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"
                            )
                       )
                 )
v-henryk-mstf
Community Support
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.


Looking forward to your feedback.


Best Regards,
Henry

Samarth_18
Community Champion
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:-

Samarth_18_0-1644224152521.png

 

 

 

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.
Appreciate your Kudos!!
Connect on Linkedin

amitchandak
Super User
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

Join us as experts from around the world come together to shape the future of data and AI!
At the Microsoft Analytics Community Conference, global leaders and influential voices are stepping up to share their knowledge and help you master the latest in Microsoft Fabric, Copilot, and Purview.
️ November 12th-14th, 2024
 Online Event
Register Here

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.