cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
bw70316 Member
Member

DAX: If count = X, then true for each year

I have hockey data and am trying to pull out the champion from a given year. To be the champion, a team must accumulate 4 wins in the final round. I have written a calculated column for this:

Finalists = IF('Database (2)'[Round] = "Final" && 'Database (2)'[Win] = 1, "win", "loss")
I want to create a second column for the actual champions and I really don't know where to begin. I can list it out logically but do not know the Dax tranlsation:

Get Team name where Round = final and Win count = 4 for a given year
 
Champions.png
 
Ignore the column title, these are finalists not champions. I have changed it.
1 ACCEPTED SOLUTION

Accepted Solutions
Anonymous
Not applicable

Re: DAX: If count = X, then true for each year

I believe a switch statement would be able to provide the results you are looking for. Something like the below:

 

Column 2 = 
    SWITCH(
        TRUE(),
            'Database (2) [Count of Champions] = 4, "True", 
            'Database (2) [Count of Champions] < 4, "False"
    )

Basically creating a condition where if the count of champions column (or whatever the updated name is) is equal to 4 then it will display "True" or "Win" and a conditon where it is less than 4 to display "False" or "Loss". 

 

You could then use a distinct count to count the number of "Wins" or "Losses" in a card visual. 

View solution in original post

1 REPLY 1
Anonymous
Not applicable

Re: DAX: If count = X, then true for each year

I believe a switch statement would be able to provide the results you are looking for. Something like the below:

 

Column 2 = 
    SWITCH(
        TRUE(),
            'Database (2) [Count of Champions] = 4, "True", 
            'Database (2) [Count of Champions] < 4, "False"
    )

Basically creating a condition where if the count of champions column (or whatever the updated name is) is equal to 4 then it will display "True" or "Win" and a conditon where it is less than 4 to display "False" or "Loss". 

 

You could then use a distinct count to count the number of "Wins" or "Losses" in a card visual. 

View solution in original post

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 110 members 1,468 guests
Please welcome our newest community members: