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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

Set up alert for temperature above 30% to your mail

Hi Team

 

I have field from the table in my Table in power bi, i want to set an alert on my dashboard using either card or gauge. How do i go about using this scenario? meaning in powerbi as to say set an alert to a user if temperature is above 30% celcious as an email? Do i do iteration function like MAX(.sum(table_name.) or Conditional function like IF temperature is 30% then do.... or else below do this...... Kindly please assist as i want to implement such to my power bi dataset, an example will be appreciated thanks team.

1 ACCEPTED SOLUTION
artemus
Employee
Employee

You wouldn't want to use SUM... there is no point in summing tempatures.

 

What you probably want is to show the tempature at the latest time point.

Something like:

temperatureLatest = SELECTCOLUMNS(TOPN(1,[TemperatureTable], [DateTime],DESC), "Temperature", [Temperature])

View solution in original post

1 REPLY 1
artemus
Employee
Employee

You wouldn't want to use SUM... there is no point in summing tempatures.

 

What you probably want is to show the tempature at the latest time point.

Something like:

temperatureLatest = SELECTCOLUMNS(TOPN(1,[TemperatureTable], [DateTime],DESC), "Temperature", [Temperature])

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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

Top Solution Authors
Top Kudoed Authors