Forum Discussion

New Member

6 years ago

Solved

Filter or grouping help

Hello, I am trying to filter with conditions and I'm struggling to work out how to manage. I have names A and B, Dates and a status ranked Final>Interim>Preliminary, so I just want to keep the h...

Need Help

mazsheps
6 years ago
I have found a solution using https://excelgorilla.com/power-bi/power-query/reach-underlying-rows-using-table-max/
v-lili6-msft works for visuals, but I was wating all the sorting done in power query editor.

v-lili6-msft

Community Support

6 years ago

hi mazsheps

For your case, you could try this simple way as below:

Step1:

Create a measure as below:

highest status = 
IF (
    MIN ( 'Table'[Status] )
        = CALCULATE (
            MIN ( 'Table'[Status] ),
            FILTER (
                ALLSELECTED ( 'Table' ),
                'Table'[Name] = MAX ( 'Table'[Name] )
                    && 'Table'[Prod Date] = MAX ( 'Table'[Prod Date] )
            )
        ),
    MIN ( 'Table'[Status] )
)

Step2:

Then you could use one of these two way to show the expected output.

1. Drag all the fields you want to show and this measure except [Status] field in a table visual.

2. Drag all the fields you want to show and [Status] field in a table visual, then drag this measure into table visual level filter and set filter is not blank