DAX Measure to Find Percentage of a Column

[Natasha93]

Hi all 🙂

I have a column in a table that shows the "resolving group" of a series of "tickets"

RESOLVING GROUP

Primary Team

Other Assignment Groups

Other Assignment Groups

Primary Team

Primary Team

Primary Team

I would like to add a card visual that shows the percentage of tickets resolved by the "Primary Team" compared to "Other Assignment Groups" based on this column. Note that it is just the two groups listed, not Primary and a bunch of other names groups.

Is this possible to do in a measure? If so, what should I use?

Or do I need to take an alternative step?

Thanks in adv for your help on this!

[tamerj1 · Accepted solution]

Hi @Natasha93 

please try

=
VAR PrimaryTeamTickets =
    CALCULATE (
        DISTINCTCOUNT ( TabeName[Ticket no.] ),
        TabeName[Resolving Group] = "Primary Team"
    )
VAR AllTickets =
    DISTINCTCOUNT ( TabeName[Ticket no.] )
RETURN
    DIVIDE ( PrimaryTeamTickets, AllTickets )