Forum Discussion
daedah
Helper II
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...
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.
daedahHelper II
Helper IIexample 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
Community Support
Community Supportdaedah ,
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.