Forum Discussion

stuart765's avatar
stuart765
Frequent Visitor
3 years ago
Solved

Separating Data in a Column for a Report

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.

Need Help
  • FreemanZ's avatar
    FreemanZ
    3 years ago

    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:

     

2 Replies

  • FreemanZ's avatar
    FreemanZ
    Super User
    3 years ago

    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: