Help on Categorizing Data

[ovetteabejuela]

Hi,

How can I achieve the output shown in Green.

**You may use Mock data found at the bottom

Hooman	Date	Sale
Richard	1-Jan	45
Richard	2-Jan	12
Richard	3-Jan
Richard	4-Jan
Richard	5-Jan	25
Tanya	1-Jan
Tanya	2-Jan	123
Tanya	3-Jan
Tanya	4-Jan	32
Tanya	5-Jan
Leonard	1-Jan	43
Leonard	2-Jan	75
Leonard	3-Jan	90
Leonard	4-Jan	71
Leonard	5-Jan	49

[v-yulgu-msft · Accepted solution]

Hi @ovetteabejuela,

Please refer to this measure:

Made sale everyday =
IF ( COUNTROWS ( FILTER ( Test, Test[Sale] = BLANK () ) ) > 0, "No", "Yes" )

Best regards,

Yuliana Gu

[Zubair_Muhammad]

@ovetteabejuela

May be a MEASURE like

Measure = COUNTBLANK(Table1[Sale])=0