Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
Solved! Go to Solution.
Hi, @gtripple
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.
Hi, @gtripple
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.
Hello @gtripple ,
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.
Pls see above explanation ❤️
Please post a sample data and your formulas.
Proud to be a Super User!
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.
@gtripple , Do you have team or something like that to group /filter if not what is expected?
I do not. I just want a way to filter by player and get someone's win%, etc
Hello @gtripple ,
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.
User | Count |
---|---|
128 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |