Forum Discussion
calculate measure repeat maintenance
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.
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?
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
🙏 🙏
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.