Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
Hi,
my problem is
I need the distinct count of sport with string consist of ball/ team but only for won = 1
the orginal column only contain team,sport,alias,name
won & current count are addcolumns
I need the expected count as result instead of current count
I'm not able to use won as filter as it as in addcolumns
this is table
team | sport | alias | name |
1 | handball | p1 | john |
1 | handball | p2 | harish |
1 | football | p5 | williams |
1 | hockey | p6 | vivek |
1 | tennis | p3 | vimal |
2 | cricket | p7 | ben |
2 | ball badminton | p4 | thomas |
2 | tennis | p8 | joseph |
2 | high jump | p3 | vimal |
this is table2
player | alias |
john | p1 |
harish | p2 |
vimal | p3 |
thomas | p4 |
calculated table
team | sport | alias | name | won | current count | expected count |
1 | handball | p1 | john | 1 | 2 | 1 |
1 | handball | p2 | harish | 1 | 2 | 1 |
1 | football | p5 | williams | 0 | 2 | 1 |
1 | hockey | p6 | vivek | 0 | 2 | 1 |
1 | tennis | p3 | vimal | 1 | 1 | 1 |
2 | cricket | p7 | ben | 0 | 1 | 1 |
2 | ball badminton | p4 | thomas | 1 | 1 | 1 |
2 | tennis | p8 | joseph | 0 | 1 | 1 |
2 | high jump | p3 | vimal | 1 | 1 | 1 |
my expected output is "EXPECTED COUNT" column
my base model has 2 tables - TABLE & TABLE2
using those 2 table I have created calculated column WON & CURRENT COUNT
my WON column is right but my CURRENT COUNT is not
my CURRENT COUNT column should only apply if WON = 1 but since WON is used as a addcolumn I'm not able to use it as a filter
this is my dax
@newbie9 could you explain the logic of what you are trying to achieve and what is the expected output?
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
my expected output is "EXPECTED COUNT" column
my base model has 2 tables - TABLE & TABLE2
using those 2 table I have created calculated column WON & CURRENT COUNT
my WON column is right but my CURRENT COUNT is not
my CURRENT COUNT column should only apply if WON = 1 but since WON is used as a addcolumn I'm not able to use it as a filter
this is my dax
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
81 | |
76 | |
61 | |
37 | |
33 |
User | Count |
---|---|
99 | |
56 | |
51 | |
42 | |
40 |