calculate measure repeat maintenance

[daedah]

Hi

I trying calculate measure of repeat maintenace within same month of each machine_name  repaired in the same reason

Example data of  2019

Table : Maintenance 

Machine_Name               Reason                    Date          

A                                      person                     1/11/2019

B                                      spare parts               3/11/2019

C                                      Using                        4/11/2019
B                                      spare parts               15/11/2019
A                                      person                      1/12/2019

Result Of November
A                                    1

B                                    2   

C                                    1

Thank you for your help 🙏

[v-yuta-msft]

@daedah ,

Create a measure using dax as below:

Result of November = CALCULATE(COUNTROWS('Table'), FILTER(ALLEXCEPT('Table', 'Table'[Machine_Name]), MONTH('Table'[Date]) = 11))

  

Community Support Team _ Jimmy Tao

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

[daedah]

Thank you so much , If I want to add conditions with a maintenance within 30 days for the same reason & Machine_name

How should I do?

[daedah]

example data

https://drive.google.com/file/d/1jejj1gxsyfmACsVSqqG7d-9JEbidFxNI/view?usp=sharing 

Requirement is  The number of job_id  for each Machine_name it repair  within 30 days from job_date  for the same reason.


Report result

🙏 🙏

[v-yuta-msft · Accepted solution]

@daedah ,

You can create a measure using dax as below:

Number of job_id per month per plate_id per reason = CALCULATE(DISTINCTCOUNT(repeat[job_id]), ALLEXCEPT(repeat, repeat[job date].[Month], repeat[plate_id], repeat[Reason]))

 

Community Support Team _ Jimmy Tao

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