Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Return1 value for multiple criteria

Hi there,   Been stuck on this for a while and appreciate any input;   I've a list of sales orders, with each order comprising of multiple order lines, and each order line can be pass or fail.  ...
Need Help
  • v-juanli-msft's avatar
    v-juanli-msft
    7 years ago

    Hi Anonymous 

    For this test data, create two measures

    fail n = CALCULATE(COUNT(Sheet5[status]),FILTER(ALLEXCEPT(Sheet5,Sheet5[order]),Sheet5[status]="fail"))

flag = IF([fail n]>0,"fail","pass")

    Add them in a table visual

     

    Best Regards

    Maggie

     

    Community Support Team _ Maggie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

AnthonyTilley's avatar
AnthonyTilley
Solution Sage
7 years ago

I had a similar issue and just used a Max value to get the overall status in a matrix.

 

i assinged a value of 1 for pass and 2 for fail and then had a measure of

Maxstatus =Max(Orders[STATUS CODE])

 

when used in a matrix with Order id as the row header and the measure above means that if any line exsists with a fail the max value will be a 2. if there are no fail lines and all lines are pass then the max value will be 1