How do I set certain conditions for Card visuals?

Hi Anonymous 

Download sample PBIX file with code/visuals shown below

What code are you using to create the current card visual?

Looking at your screenshots the Status column is text so presumaby this contains things like "Open" and "Closed" ?

OK so we don't know how you are calculating the number of open tickets but I'm guessing it will be something like this

Open Tickets = CALCULATE(COUNTROWS(RequestDetails), FILTER('RequestDetails', 'RequestDetails'[Status] = "Open"))

which returns a number.

I'm assuming that in the images above the text Open Tickets is the Category Label for the card?  In which case you need to turn this off so the card just displays a number

Now we can alter the Open Tickets measure to account for 0/Blank, 1 or more than 1 open tickets.

Open Tickets = 

VAR _OpenTickets = CALCULATE(COUNTROWS(RequestDetails), FILTER('RequestDetails', 'RequestDetails'[Status] = "Open"))

RETURN

SWITCH(
    
    TRUE(),
    
    _OpenTickets = 0, "No Open Tickets",

    _OpenTickets = 1, "1 " & UNICHAR(00010) & "Open Ticket",

    _OpenTickets  & UNICHAR(00010) & " Open Tickets"

)

Regards

Phil