Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

How do I set certain conditions for Card visuals?

Sorry if I haven't asked the question in the best possible format, but it's quite difficult to explain. But I've got images to help explain my problem. Currently I've got a drilldown page that shows ...
Need Help
  • PhilipTreacy's avatar
    PhilipTreacy
    5 years ago

    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

v-deddai1-msft's avatar
v-deddai1-msft
Icon for Community Support rankCommunity Support
5 years ago

Hi Anonymous ,

 

You can use the following meausre :

 

Open Tickets = var vTickets = SUM(RequestDetails[Status])+0

Return IF(OR(vTickets<=1, ISBLANK(vTickets)), vTickets & " Open Ticket", vTickets & " Open Tickets")

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

Best Regards,

Dedmon Dai

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hey v-deddai1-msft appreciate the reply. 

I've just implemented this measure, I've caleld it (TicketMeasure), however, when I put it into the fields the visual doesn't work. I'll show you below.

In status I do already have some filters that only count a number of "open" tickets, maybe that could be interfering? But I'm not sure.