Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Natasha93
Frequent Visitor

DAX Measure to Find Percentage of a Column

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!

1 ACCEPTED SOLUTION
tamerj1
Super User
Super User

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 )

View solution in original post

1 REPLY 1
tamerj1
Super User
Super User

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 )

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors