Select specific rows based on calculation
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!