Count of blanks based on distinct count of another column

[JSWILCOX1980]

i have a source table where i have data that when entered created 3 separate columns, Lets call the form Entry "LABEL" which when the user adds more than one label in the field, it creates mulitple columns.  So you end up with mutiple columns -  Label 1 "apple", Label 2 "orange", Label 3 "pear".  So i had to Unpivot columns in order to quantify the labels appropriately.  This has caused some other issues now, it basically has tripled the rows and data in the table so counts must be DISTINCT most of the time if not all.

Sample Data:

ISSUE ID	REQUEST	CREATED	RESOLVED	Labels
111222	REQ-101	1/1/23		Apple
111222	REQ-101	1/1/23		Orange
111222	REQ-101	1/1/23		Pear
333444	REQ-102	3/17/23	3/26/23	Orange
333444	REQ-102	3/17/23	3/26/23	Grape
333444	REQ-102	3/17/23	3/26/23	Strawberry
555666	REQ-103	5/4/23		Orange
555666	REQ-103	5/4/23		Pear
666777	REQ-104	6/7/23	6/15/23	Apple
666777	REQ-104	6/7/23	6/15/23	Orange
666777	REQ-104	6/7/23	6/15/23	Strawberry
888999	REQ-105	8/4/23		Plum
888999	REQ-105	8/4/23		Pear

Here is where i am having trouble :

What i would like to to do is have a calculation show me How many Total Created Cases , Total Resolved Cases and Total of Unresolved (based on blanks in RESOLVED column)

TableCountBlanks = COUNTBLANK('Table'[Resolved])

Any assistance would be greatly appreciated!

Jeremy Wilcox

[Fowmy]

@JSWILCOX1980 

Here are the three measures that you need:

Created Tickets = DISTINCTCOUNT( Table4[ISSUE ID] )

-------------------------------------------------------

Resolved Tikets = 
CALCULATE(
    [Created Tickets],
    TableName[RESOLVED] <> BLANK()
) 

-------------------------------------------------------

Unresolved Tickets = [Created Tickets] - [Resolved Tikets]