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

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
chintu94
New Member

IF Statement help or Conditional Card

I have a calcuated column in Power BI that I use it to display in Report "Visual Card" that shows SUM value of that column (Delta Hrs Per Day & FTE Needed). I only want to show the value in that "Visual Card" if the SUM is Negative Value and dont show if the SUM is Positive Value in those columns, can anyone help with the IF statement or Contitional Card or anything that i can use?

 

Below is the Card that i use in the Visualization area

chintu94_0-1674156797064.png

 

 

Below is the Column from the "Data" table

chintu94_1-1674156853022.png

 

 

1 ACCEPTED SOLUTION
tackytechtom
Super User
Super User

Hi @chintu94 ,

 

In case the SUM value in the visual is a measure, you could use the following DAX:

Measure2 = IF ( [Measure] > 0, "", [Measure] )

 

 

Otherwise you could also create a measure like this:

Measure = IF ( SUM ( table[col] ) > 0, "",  SUM ( table[col] ) )

 

The "" you could substitute with BLANK(), too if that works for you.

 

Let me know if this helps 🙂

 

 

/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/



Did I answer your question➡️ Please, mark my post as a solution ✔️

Also happily accepting Kudos 🙂

Feel free to connect with me on LinkedIn! linkedIn

#proudtobeasuperuser 

View solution in original post

2 REPLIES 2
chintu94
New Member

Thank you so much

tackytechtom
Super User
Super User

Hi @chintu94 ,

 

In case the SUM value in the visual is a measure, you could use the following DAX:

Measure2 = IF ( [Measure] > 0, "", [Measure] )

 

 

Otherwise you could also create a measure like this:

Measure = IF ( SUM ( table[col] ) > 0, "",  SUM ( table[col] ) )

 

The "" you could substitute with BLANK(), too if that works for you.

 

Let me know if this helps 🙂

 

 

/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/



Did I answer your question➡️ Please, mark my post as a solution ✔️

Also happily accepting Kudos 🙂

Feel free to connect with me on LinkedIn! linkedIn

#proudtobeasuperuser 

Helpful resources

Announcements
July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

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