Forum Discussion
Helper IIcalculate measure repeat maintenance
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 🙏
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.
4 Replies
v-yuta-msftCommunity Support
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.
daedahThank 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🙏 🙏