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  ...
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:

     

stuart765's avatar
stuart765
Frequent Visitor
3 years ago

It worked and thank you.