cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
FilipK
Helper II
Helper II

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
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

Top Solution Authors
Top Kudoed Authors