Forum Discussion
Count by criteria
Hi, StephenGW
Try to create 2 measures like below:
_AuditTime:_AuditTime = MAX('Data'[Audit Time])Probation:
Probation = VAR _table = SUMMARIZE ( FILTER ( 'Data', RANKX ( ALLEXCEPT ( 'Data', Data[Area] ), [_AuditTime],, DESC ) <= 10 && [Pass/Fail] = "Fail" ), [Area] ) RETURN IF ( MAX ( 'Data'[Area] ) IN _table, "Yes", "No" )Note:
There are some data errors in your sample data. I have corrected the errors when using them.
Result:
Please refer to the attachment below for details
Hope this helps.
Best Regards,
Community Support Team _ Zeon Zheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Is there anyway to make it ignore the two slicers I mentioned while keeping the other 2? When I change months it changes the outcome of this measure?
Stephen
Hi, StephenGW
Sorry for not checking the messages in time.
You can add the filter you want to keep in the ALLEXCEPT function
Something like this:
Hope this is what you want.
Best Regards,
Community Support Team _ Zeon Zheng