Select specific rows based on calculation

[KoenGerrits]

Hi Power BI experts,

I am quite new to Power BI and I cannot figure out how to visualise this properly.

I have the following table:

Temperature	Description1	Description2	Description3
24	Normal	Normal	Normal
25	Alarming	Alarming	Normal
26	Alarming	Alarming	Normal
27	Crisis	Crisis	Alarming

For simplicity lets assume that the descriptions are from 3 different persons

I made a calculation about the maximum temperature for the coming two weeks, and I want to visualise the matching descriptions. So say for example that the max temperature will be 26, I want to see the following:

Description1	Description2	Description3
Alarming	Alarming	Normal

Can somebody help me out?

Thanks in advance!

[KoenGerrits]

I should add that I work with DirectQuery, which makes me unable to create new tables.