Forum Discussion
Filter on unique values
Order Created week Reported week Priority Status 1000888 1 1 urgent Initiative 1000888 1 2 urgent In progress 1000888 1 3 urgent Evaluate 1000989 2 2 low In progr...
Hi Anonymous ,
Would you please refer to the following measure:
Measure = CALCULATE(DISTINCTCOUNT('Table'[Order]), FILTER('Table','Table'[Created week] = MAX('Table'[Created week])&& CALCULATE(MAX('Table'[Priority]),FILTER(ALLEXCEPT('Table','Table'[Order]),'Table'[Reported week] = MIN('Table'[Reported week]))) in {"high", "urgent"}))If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Dedmon Dai
Hi Anonymous ,
Would you please refer to the following measure:
Measure = CALCULATE(DISTINCTCOUNT('Table'[Order]), FILTER('Table','Table'[Created week] = MAX('Table'[Created week])&& CALCULATE(MAX('Table'[Priority]),FILTER(ALLEXCEPT('Table','Table'[Order]),'Table'[Reported week] = MIN('Table'[Reported week]))) in {"high", "urgent"}))
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Dedmon Dai