Show if machine active on date//week/month measure

[ratercero]

Hello, 

I have a list of transactions per machine and date, Im looking for a measure that returns the amount of machines activated filtered by date or week. 

I tried this but returns the amount of times a machines was active on a day :

MACH_DAY_COUNT = CALCULATE(COUNTA(t_Batch[c_MachineId]),t_Batch[ASSIGNED_DATE])

How can I count just once per machine and date?

Thank you

[parry2k]

You should add a calendar table and set relationship with your data and then use field from your calendar table (like week, date, year , month) to get desired output.

There are lots of posts around it, and here is quick link to get started on how to create calendar table in  powerbi

[ratercero]

Hello @parry2k,

I already have a date table, the issue is counting each machine once per day, even if the timeline visual is filtered by day/week or month.

if you have sugestions for the calculation I will apreciate.
Thank you

[parry2k]

Did you put machine id on legend?

[ratercero]

@parry2k, I do not understand your question. please elaborate.

RT

[parry2k]

May be I was not clear in my input, can you share screen shot of current graph/report and it will help to guide you.

[ratercero · Accepted solution]

@parry2k 

I used:

MACH_COUNT = DISTINCTCOUNT(t_Batch[c_MachineId]) 

and works but partially, because some times we stop one machine and start another one, so when we look at the week shows we have more machines in a week than we have daily: