Finding group maximun in analysis services

[Anonymous]

Hello world, 
I have this is issue

as you can see a single invoice number can have multiple statuses. I want to create a measure and filter by it so that if invoice number has 2 statuses, then the final status of the whole invoice number would be validated, in not the leave the status as is. 
I was considering a group calculation with min/max but I couldn't make it working. 
Any ideas?
Thanks in advance

[Jihwan_Kim · Accepted solution]

Hi, @Anonymous 

Please check the below picture and the measure.

Status Measure =
VAR currentinvoice =
MAX ( 'Table'[AP Invoice Number] )
RETURN
IF (
COUNTROWS (
FILTER ( ALL ( 'Table' ), 'Table'[AP Invoice Number] = currentinvoice )
) > 1
&& "Validated"
IN SUMMARIZE (
FILTER ( ALL ( 'Table' ), 'Table'[AP Invoice Number] = currentinvoice ),
'Table'[AP Invoice Status]
),
"Validated",
SELECTEDVALUE ( 'Table'[AP Invoice Status] )
)

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

Linkedin: linkedin.com/in/jihwankim1975/

Twitter: twitter.com/Jihwan_JHKIM

[Fowmy]

@Anonymous 

Add the following measure:

Final Ivoice Status = 
var __current = MAX(Table4[AP Invoie No]) return
IF(
    CALCULATE(
        COUNTROWS(Table4),
        Table4[AP Invoie No] = __current,
        REMOVEFILTERS(Table4)
    ) = 2,
    "Validated",
    UNICHAR(8302)
)

[Anonymous]

Wish I could also click as solution on this one too cause it works great too!Thanks!