Count/CountA counting wrong category

[Anonymous]

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.

[v-alq-msft · Accepted solution]

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.

[bhagyashripatil]

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]

Pls see above explanation ❤️

[danextian]

Please post a sample data and your formulas.

[Anonymous]

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]

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

[Anonymous]

I do not. I just want a way to filter by player and get someone's win%, etc

[bhagyashripatil]

Hello @Anonymous ,

Is your data in this format ?

Please give some sample masked data, so that we get better idea. You can also give the sample output which you expect.