topic Re: Count consecutives based on an Criteria in DAX Commands and Tips

Count consecutives based on an Criteria

Anonymous — Thu, 25 Feb 2021 18:41:20 GMT

Hello, i would like to count the number of Events that are out of especificacion (IN = 0, OUT = 1), based on time and criteria,

For example My variable has criteria for every 3 points out, should be an anomaly, but if is for example 10 consecuite points out, it should also count as 1 anomaly,

VARIABLE

FECHA	HORA I	HORA F		IN = 1, OUT = 0	CRITERIA
1/02/2021	00:00	08:00	2.09	0	3
1/02/2021	08:00	16:00	3.33	0	3
1/02/2021	16:00	00:00	2.13	0	3
2/02/2021	00:00	08:00	4.34	1	3
2/02/2021	08:00	16:00	3.29	0	3
2/02/2021	16:00	00:00	8.81	1	3
3/02/2021	00:00	08:00	9.37	1	3
3/02/2021	08:00	16:00	5.37	1	3

Re: Count consecutives based on an Criteria

stevedep — Thu, 25 Feb 2021 19:10:20 GMT

Can you add expected output to the table?

Re: Count consecutives based on an Criteria

Anonymous — Thu, 25 Feb 2021 20:36:52 GMT

Re: Count consecutives based on an Criteria

stevedep — Thu, 25 Feb 2021 20:55:31 GMT

Thanks, please use the following;

https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216

Re: Count consecutives based on an Criteria

Anonymous — Fri, 26 Feb 2021 01:39:33 GMT

https://we.tl/t-TRRsCFTW7g