Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
Hi all,
I would like to create a measue to show the overall oil condition of multiple different oil tests.
In the screenshot below you can see different results for multiple components of one maschine (action needed (action), caution, normal (all good)) and I would like to summarize those results to show them in an end result per maschine.
The logic should be this:
All components normal -> result: normal
At least one component caution but rest normal -> result: caution
At least one component action -> result: action
Maybe someone has an idea how to create such measure?
Solved! Go to Solution.
Try to create a new with the code below:
Works perfectly fine, thank you!
Try to create a new with the code below: