Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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