Forum Discussion

Liam01's avatar
Liam01
Icon for Helper I rankHelper I
4 years ago
Solved

Find values based on a condition but return all occurrences where there are multiples of the value

Hello,   Help required please and hopefully I explain this correctly.   I'd like to be able to find where a value meets a condition but it returns all occurrences of that value including the ones...
Need Help
  • Kaly's avatar
    Kaly
    4 years ago

    Hi Liam01 ,

    According to your description, here's my solution. Create a measure.

    Measure =
IF (
    COUNTROWS (
        FILTER (
            ALL ( 'Table' ),
            'Table'[Order number] = MAX ( 'Table'[Order number] )
                && 'Table'[Sheet] = "A"
        )
    ) > 0,
    1
)

    Put the measure in the visual filter and select its value to 1.

    Get the correct result.

    Best Regards,

    Kaly

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
4 years ago

Change the first step ("Source" ) to point to your actual data source.

Liam01's avatar
Liam01
Icon for Helper I rankHelper I
4 years ago

Hello,

 

I've edited the part of the text in bold below to the name of query I want it to relate to but I get the following error - 

 

let

    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMjQyNjFV0lFyVIrVQfCcwDwQxwzOA3HM4SphPFQ5ZzAPxLGAy6HyQBxLOM/CEmgj3EwYD2hKLAA=", BinaryEncoding.Base64)

 

Thanks