Separating Data in a Column for a Report

[stuart765]

I am creating a report (Cards) and want to have separate cards for "New" and "Used". The data I am using lists "New" and "Used" in the same column (Catagory). 

Category

New

Used

New

New

Used

How do I setup a Measure to quantify each category separately?

Thank you.

[stuart765]

It worked and thank you.

[FreemanZ · Accepted solution]

hi @stuart765 

not sure if i fully get you, you may plot two card visuals with measures like:

NewCnt = 
COUNTROWS(
    FILTER(
        TableName,
        TableName[Category]="New"
    )
)

UsedCnt = 
COUNTROWS(
    FILTER(
        TableName,
        TableName[Category]="Used"
    )
)

it worked like: