Filter By Group

[Diimoo1]

I have data that looks like this :

Name	Group 1	Group 2	Group 3
Joe		1
Moe	1	1
King	1		1
Penn			1
Zhee	1

And would like create a new flag measeure like this  ( returns first  empty row by group):

Name	Group 1	Group 2	Group 3	Flag
Joe		1		Group 1
Moe	1	1		Group 3
King	1		1	Group 2
Penn			1	Group 1
Zhee	1			Group 2

Thanks for your help

[Diimoo1]

I have data looks like this:

Name	Group 1	Group 2	Group 3
Joe		1
Moe	1	1
King	1		1
Penn			1
Zhee	1

Would like create flag column/measure the return the first blank celll: Result will look like this:

Name	Group 1	Group 2	Group 3	Flag
Joe		1		Group 1
Moe	1	1		Group 3
King	1		1	Group 2
Penn			1	Group 1
Zhee	1			Group  2

I tried to capture by filtering but no luck. Please see if you can be help on this Dii

[v-juanli-msft · Accepted solution]

Hi @Diimoo1

Formula below will achieve your requirement.

Measure = IF(ISBLANK(MAX([Group 1])),"Group1",IF(ISBLANK(MAX([Group 2])),"Group2",IF(ISBLANK(MAX([Group 3])),"Group3")))

Best Regards

Maggie

[Diimoo1]

Thanks Maggie..That works