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.

     

Kaly's avatar
Kaly
Icon for Resolver II rankResolver II
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.

 

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

    Hi Kaly

     

    That seems to have done the trick and what I was after, thanks for that.

     

    Thanks