Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
Hi,
I am relatively new to using DAX and was wondering if the below excel formula be converted into DAX?
=IF(COUNTIF('County Player List'!A:A,[@County])>0,"Yes", "No")
Solved! Go to Solution.
@sb2848 COUNTIF is COUNTX(FILTER(...),...) in DAX. CO-CU Excel to DAX Translation - Microsoft Power BI Community
Hi, @sb2848
Here are the steps you can refer to :
(1)This is my test data:
(2)We can click "New Column" to create a calculated column :
Flag = var _current_cou='County List'[Country]
var _count =COUNTROWS( FILTER('All Data 2021 & 2022','All Data 2021 & 2022'[County] = _current_cou ))
return
IF(_count >0 ,"Yes" ,"No")
(3)The result is as follows:
If this method does not meet your needs, you can provide us with your special sample data and the desired output sample data in the form of tables, so that we can better help you solve the problem.
Best Regards,
Aniya Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
I tried a different approach converting the below excel formula into DAX, I tried a different approach, but I am not getting the right output. Hoping you can point me in the right direction.
=IF(COUNTIF('County List'!A:A,[@County])>0,"Yes", "No")
my approach
County = CALCULATE(COUNT('County List'[County] >0, FILTER('All Data 2021 & 2022', 'All Data 2021 & 2022'[County] = "Yes" || 'All Data 2021 & 2022' [County] = "No"))
Hi, @sb2848
Here are the steps you can refer to :
(1)This is my test data:
(2)We can click "New Column" to create a calculated column :
Flag = var _current_cou='County List'[Country]
var _count =COUNTROWS( FILTER('All Data 2021 & 2022','All Data 2021 & 2022'[County] = _current_cou ))
return
IF(_count >0 ,"Yes" ,"No")
(3)The result is as follows:
If this method does not meet your needs, you can provide us with your special sample data and the desired output sample data in the form of tables, so that we can better help you solve the problem.
Best Regards,
Aniya Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
@sb2848 COUNTIF is COUNTX(FILTER(...),...) in DAX. CO-CU Excel to DAX Translation - Microsoft Power BI Community
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 |
---|---|
58 | |
55 | |
55 | |
38 | |
29 |
User | Count |
---|---|
78 | |
62 | |
45 | |
40 | |
40 |