Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
97 | |
96 | |
81 | |
74 | |
66 |
User | Count |
---|---|
129 | |
106 | |
106 | |
86 | |
72 |