Return String Column by valuating numbers column

[New_be]

Hi expert,

Problem:

I have a problem with one of my report. I try to return/create a column for string by valuating a number column. Below I have an example.

Scenario:
Left image are showing an orderID along with its sequence (SEQ). But here, let say if we filter on "PROCESS = PRO", then we will only be able to see "SEQ" is equal to 6. What I wanted to create is, although we filter on the process column, I will have the MIN sequence. 

Below image is my desired table. I only be able to create "MIN SEQ" column.  But I don't know how to get "MIN PROCESS" column. 

Can someone please advise and show to me how I can work around to get "MIN PROCESS" column? Thanks in advance!

[ghoshabhijeet · Accepted solution]

@New_be  Thanks for sharing your query.

Here is my solution. Please try this.

Create the following two measures and use it on your table:

Min SEQ = CALCULATE(MIN('DataTable'[SEQ]), REMOVEFILTERS('DataTable'))

Min PROCESS = 

VAR MinSEQ = [Min SEQ]

RETURN

CALCULATE(MIN('DataTable'[PROCESS]), 'DataTable'[SEQ] = MinSEQ, REMOVEFILTERS('DataTable'))

Here is the result:

** If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution, so that it comes in top of the search and help others. Thank you !

Good Luck 👍