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
FilipK
Resolver I
Resolver I

Display multiple threshold violations of last 24h with measures and rules table

I hope this problem is not too complex to be covered here.

Imagine you've got an event table like this:

deviceIDtimestampFeature 1Feature 2Feature 3
D34/13/202127613089
D144/24/2021109448240
D134/26/202179216272

 

There are several calculated features derived from the given features:

      (F1+F2)/2F1-F2F1+F3
deviceIDtimestampFeature 1Feature 2Feature 3Measure 1Measure 2Measure 3
D34/13/202127613089203146365
D144/24/2021109448240278,5-339349
D134/26/202179216272147,5-137351

 

I now want to apply a threshold check that proves if Measure 1..3 are above certain thresholds that are stored in a separate table:

EffectCalculationPropertyThreshold1Threshold2Threshold3
E1(Feature1+Feature 2)/290400450480
E2Feature1-Feature 31402050100
E3Feature1+Feature 290700800850

 

The target is to have one final table that shows which deviceId has exceed which threshold within the last 24h.

 

I put the pbi dataset here: https://easyupload.io/a4dgtg

I searched if there is already a solution out there but didn't find. What is your suggesestion? How would approach that topic?

1 REPLY 1
v-jayw-msft
Community Support
Community Support

Hi @FilipK ,

 

There's no data in the shared pbix file. And I doubt that you can put different measures in same column.

 

Best Regards,

Jay

Community Support Team _ Jay
If this post helps, then please consider Accept it as the solution
to help the other members find it.

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.