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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Joeri_Huitema
New Member

Need help with DAX Measure to check values

Hi, 

 

So i have an streaming data set, and i created an measure to get the latest value of an item. 

 

What i want to do is: i have 2 temperature sensors, if one of them goes above 25 degrees i want to return an 1(like i did for one is  temp_green = IF('RealTimeData'[Latest_temp] < 25, 1, 0). How do i manage to create an IF(latest_temp > 25 and device = 'Device1' or 'Device2' return 1

 

Or like if a device has an measure of > 25 turn something to true so i can do this IF(temp = true, 1, 0)

 

I hope someone can help me

1 REPLY 1
VahidDM
Super User
Super User

HI @Joeri_Huitema 

 

Can you post sample data as text and expected output?
Not enough information to go on;

please see this post regarding How to Get Your Question Answered Quickly:
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

Name of column and structure of your table is important.

 

BTW, You need somthing like this:

IF('RealTimeData'[Latest_temp] < 25 && ('RealTimeData'[device ]="Device1"|| 'RealTimeData'[device ]="Device2", 1, 0)

Appreciate your Kudos!!
LinkedIn:www.linkedin.com/in/vahid-dm/

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 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.