Find percentage of points that are within a range

[Syndicate_Admin]

Hello

infinitely appreciate if you can help me with the next consultation,

I have a table with the following columns, what I need is to know the percentage of the time that the temperature and humidity are in range, it would be temperature between 17 and 25 and Humidity between 40 and 60.

The two ranges of humidity and temperature have to coincide, but I do not give with the solution.

I appreciate any help.

Greetings.

In the image that is a scatter plot is reflected my doubt.

ID_LECTURA	ID_CONTADOR	MEDIA_DIA	DATE	PROBE
546127	13132	28	11/07/2021	Temperature
547866	13132	27	12/07/2021	Temperature
546732	13123	22	13/07/2021	Temperature
548471	13123	19	14/07/2021	Temperature
546128	13133	519	11/07/2021	Humidity
547867	13133	513	12/07/2021	Humidity
546733	13124	458	13/07/2021	Humidity
548472	13124	458	14/07/2021	Humidity

[v-stephen-msft · Accepted solution]

Hi @sunnypb ,

Learn about how to highlight in the scatter chart, refer to

http://sqljason.com/2018/03/highlighting-scatter-charts-in-power-bi-using-dax.html

https://blog.enterprisedna.co/scatter-charts-in-power-bi-highlighting-key-points/

Or you can try to use zoom slicer to similarly highlight the value within the range you want.

Turn on the zoom slicer in Format.

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Syndicate_Admin]

Thank you very much for the information, I will keep you in mind!!!!!, Greetings!!!!!!

[v-stephen-msft]

Hi @sunnypb ,

You are welcome, if my reply is helpful to you, you can mark it as an answer, and more people will benefit.

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Syndicate_Admin]

Attached image of the problem, I just want to tell what is highlighted.

[TheoC]

Hi @Syndicate_Admin

I recommend using Power Query to perform following steps:

1. Unpivot PROBE and MEDIA_DIA columns

Either as a Custom Column in Power Query or a Calculated Column in Power BI Desktop:

2. Create a Custom Column or a Calculated Column with the conditions you require (e.g. Temperature 17 and 25 and Humidity between 40 and 60) using IF ( AND (....) and allocate Yes else No.

Once the above is done, you can use the count of YES divided by COUNTROWS (Table) to give you your percentage.

Hope this helps!

Theo

[Syndicate_Admin]

Thank you for the prompt response,

I applied the following formula after doing Unpivot

RANGE = IF(AND(medias_diarias_sensores[TEMPERATURE]>17,medias_diarias_sensores[TEMPERATURE]<25),"IN RANGE")&IF(AND(medias_diarias_sensores[HUMIDITY]>40,medias_diarias_sensores[HUMIDITY]<60),"IN RANGE")

Now, how would I do the count?, I am not very expert in DAX, a thousand thanks in advance.

Greetings.