Counting number of row entries/calendar day and summarizing those values on a calculated table

[Anonymous]

Hi there,

I'm really new to using Power BI and I was hoping you could give me some quick help on a question. I work for a factory and I'm creating a dashboard for stops. I have multiple rows of stops with dates associated with them but I want to be able to count the # of stops entries/day. I have a column with the date & time and a column with the reason for the stop. I was thinking I should create a calculated table to summarize information by day like this one, given that for 1 day I might have 50 entries for stops, but I want to be able to have a quick summary that is linked to the stops entries raw data to summarize how many stops they had for example for July 2nd 2019. I'm trying to count the # of entries in my raw data/calendar day without using a visual since I need to get these numbers to then create a measure and use that measure for visuals.

I'd really appreciate any help you can provide!

Thanks,

[Anonymous]

@parry2k ,

I still don't understand how to complete those 3 for the calculation in the formula below at once. Could you explain?

Thanks,

[parry2k]

@Anonymous you don't need to create seperate summarize table, just add a measure and whatever granularity you will pick , it wil work.

ALthough the best practice is to add Date table in your model whihc will allows to have better control for time intelligence, there are many posts on how to add date table in your model.

the simple measure you need for this is

# of Stops = COUNTROWS( YourTable )

Now when you drop a date and/or reason of stop, alongwith above measure, you will get count of stops.

[Anonymous]

Hi @parry2k ,

The only reason why I didnt want to have it as a measure is because I'll be using this stops/day as part of another formula. Basically I need to do this 3 times:

1. to find stops/calendar day for each production line

2. to sum all minutes the line was running/calendar day

3. to sum all minutes the line was not running/calendar day

And finally use this formula:

Stops/schedule time = stops per day/(uptime per day - downtime per day)*1440

Thats why I figured I had to get a new table which would have items 1-3 and then on the 4th column add this stops/schedule time as a measure

[parry2k · Accepted solution]

@Anonymous you can still achieve all this, you don't need seperate table or something like this. DAX is very powerful language