Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

Reply
idymkowski
New Member

Creating a condition based event counter

I have a dataset with time and inventory levels.  I want to create a counter (within a designated time period) of the # of unique rows where the inventory drops below a specified limit (in this example below 1000).  In the spreadsheet example attached, there are 4 instances I'd like to have triggered.  If I were grouping by hour, there would be one hour with 2 occurances and two hours with 1 occurance each.  Any help would be greatly appreciated.  Beyond this, I'm also going to be interested in calculating the length of time the inventory stayed below the limit.  Thanks in advance.

 

idymkowski_0-1624043391980.png

 

 

4 REPLIES 4
HashamNiaz
Solution Sage
Solution Sage

Hi @idymkowski !

 

You can create a custom column using below DAX;

 

IsBelow = IF(Table[Inverntory] < 1000, 1, 0)

 

This will give you a 1/0 flag whether Inventory is below the limit or not, now you can use this column to create a measure which will sum / count these occurences.

 

BelowLimit = SUM(Inventory[IsBelow])

 

Regards,

Hasham

If I am reading that correctly, it will flag a "1" for each occurance below 1000.  For the first part of my question, I'm only looking for the flag to be there for the 1st record below 1000 (and then reset once the inventory rises above 1000 again).

 

Hi @idymkowski !

 

Got it, please paste sample data for your problem. I have overlooked your initial requirement.

 

Regards,

Hasham

a sample spreadsheet was in the original post.  Do you need more than that?

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.