Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Count/CountA counting wrong category

This is such a simple problem that I have spent HOURS trying to solve with no avail.

I have a table with plenty of categories, say A, B, C, D, etc. I have a measure that Counts values in column A, and filters them by name into a table. I have another identical measure for column B, but for some reason, it just returns identical values as the column A measure. It makes no sense and I'm ripping my hair out over here.

My table looks like this:

Name  |  Count of A  |  Count of B

Name1          3                      3
Name2          7                      7
Name3          4                      4          

and so on when A and B in reality have very different values. I don't understand what's happening. Please help me <3.

Need Help
  • v-alq-msft's avatar
    v-alq-msft
    5 years ago

    Hi, Anonymous 

     

    Based on your description, I assume that you want to filter by player and get win% for each player. I created data to reproduce your scenario. The pbix file is attached in the end.

    Table:

     

    Names(a calculated table):

    Names = 
DISTINCT(
    UNION(
        DISTINCT('Table'[Winner's Name]),
        DISTINCT('Table'[Loser's Name])
    )
)

     

    You may create a measure as below.

    Win % = 
var result = 
DIVIDE(
    COUNTROWS(
        FILTER(
            ALL('Table'),
            [Winner's Name]=SELECTEDVALUE(Names[Name])
        )
    ),
    COUNTROWS(
        FILTER(
            ALL('Table'),
            OR(
                [Winner's Name]=SELECTEDVALUE(Names[Name]),
                [Loser's Name]=SELECTEDVALUE(Names[Name])
            )
        )
    )
)
return
IF(
    ISBLANK(result),
    0,
    result
)

     

    Result:

     

    Best Regards

    Allan

     

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

     

8 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      I can't provide data because it's sensitive. However, I have isolated the problem. 

      My dataset is essentially [game_id] [winner's name] [loser's name] .

      The reason I am having issues is that when I put [Count of Wins] and [Count of Losses] into a table, I don't have a common "name" column to filter them both into. 

      • amitchandak's avatar
        amitchandak
        Super User
        5 years ago

        Anonymous , Do you have team or something like that to group /filter if not what is expected?

  • bhagyashripatil's avatar
    bhagyashripatil
    Advocate I
    5 years ago

    Hello Anonymous ,

     

    Try ignoring any filters applied on the column, on which you are calculating Measure 'B'. You can achieve this in your DAX, by using ALL( ) function in your filter context of DAX.

     

    Or you can share your masked DAX, so that I can get more clarity on your issue.

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Pls see above explanation ❤️

  • v-alq-msft's avatar
    v-alq-msft
    Community Support
    5 years ago

    Hi, Anonymous 

     

    Based on your description, I assume that you want to filter by player and get win% for each player. I created data to reproduce your scenario. The pbix file is attached in the end.

    Table:

     

    Names(a calculated table):

    Names = 
DISTINCT(
    UNION(
        DISTINCT('Table'[Winner's Name]),
        DISTINCT('Table'[Loser's Name])
    )
)

     

    You may create a measure as below.

    Win % = 
var result = 
DIVIDE(
    COUNTROWS(
        FILTER(
            ALL('Table'),
            [Winner's Name]=SELECTEDVALUE(Names[Name])
        )
    ),
    COUNTROWS(
        FILTER(
            ALL('Table'),
            OR(
                [Winner's Name]=SELECTEDVALUE(Names[Name]),
                [Loser's Name]=SELECTEDVALUE(Names[Name])
            )
        )
    )
)
return
IF(
    ISBLANK(result),
    0,
    result
)

     

    Result:

     

    Best Regards

    Allan

     

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