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.
Hi,
Would someone know how I can convert my Excel formula to DAX? It's already 2 weeks, I tried every COUNT formula in PowerBI but no luck. Any suggestion is appreciated. Thank you!
=COUNTIFS('Scorecard-All'!H:H,">3%",C:C,">00:02:00",'Scorecard-All'!J:J,M2)/COUNTIF('Scorecard-All'!J:J, M2)
Solved! Go to Solution.
@Anonymous , it would something like
countx('Scorecard-All', if('Scorecard-All' [H]>.03 && 'Scorecard-All'[C] > time(,2,0)),'Scorecard-All'[J] )/count('Scorecard-All'[J] )
Can you share sample data and sample output in table format?
@Anonymous - You may find this helpful:
https://community.powerbi.com/t5/Community-Blog/Excel-to-DAX-Translation/ba-p/1060991
You generally replace COUNTIF with a COUNTX statement or a CALCULATE statement.
@Anonymous , it would something like
countx('Scorecard-All', if('Scorecard-All' [H]>.03 && 'Scorecard-All'[C] > time(,2,0)),'Scorecard-All'[J] )/count('Scorecard-All'[J] )
Can you share sample data and sample output in table format?
Hi @amitchandak,
Thanks for this! I will try it and let you know! Below is the sample data that I am using to compute the "Buffering > 3% of viewing duration" column.
Sample Output:
Country | Buffering > 3% of viewing duration |
Canada | 4.62% |
-------------------------------
Sample Data:
Sum of Buffering | % buffering | Country |
0:00:02 | 1% | Canada |
0:09:50 | 17% | Canada |
0:00:01 | 0% | Canada |
0:00:01 | 0% | Canada |
0:03:05 | 26% | Canada |
0:00:01 | 0% | Canada |
0:00:17 | 0% | Canada |
0:00:04 | 0% | Canada |
0:00:01 | 0% | Canada |
0:00:01 | 0% | Canada |
0:00:01 | 0% | Canada |
0:02:57 | 8% | Canada |
0:00:01 | 0% | Canada |
0:00:01 | 0% | Canada |
0:00:01 | 0% | Canada |
0:00:00 | 0% | Canada |
0:00:02 | 0% | Canada |
0:00:02 | 0% | Canada |
0:00:00 | 0% | Canada |
0:00:01 | 0% | Canada |
0:00:11 | 0% | Canada |
0:00:14 | 0% | Canada |
0:00:03 | 0% | Canada |
0:00:05 | 0% | Canada |
0:00:02 | 0% | Canada |
0:00:00 | 0% | Canada |
0:00:01 | 0% | Canada |
0:00:01 | 0% | Canada |
0:00:00 | 0% | Canada |
0:00:01 | 0% | Canada |
0:00:01 | 0% | Canada |
0:00:00 | 0% | Canada |
0:00:01 | 0% | Canada |
0:00:07 | 0% | Canada |
0:00:01 | 0% | Canada |
0:00:00 | 0% | Canada |
0:00:02 | 0% | Canada |
0:00:02 | 1% | Canada |
0:00:01 | 0% | Canada |
0:01:13 | 3% | Canada |
0:00:13 | 0% | Canada |
0:01:06 | 4% | Canada |
0:00:00 | 0% | Canada |
0:00:01 | 0% | Canada |
0:00:03 | 0% | Canada |
0:00:00 | 0% | Canada |
0:00:21 | 1% | Canada |
0:00:13 | 0% | Canada |
0:00:21 | 1% | Canada |
0:00:01 | 0% | Canada |
0:00:01 | 0% | Canada |
0:00:25 | 0% | Canada |
0:00:04 | 0% | Canada |
0:00:51 | 1% | Canada |
0:00:31 | 1% | Canada |
0:00:21 | 0% | Canada |
0:00:10 | 1% | Canada |
0:01:55 | 6% | Canada |
0:00:04 | 0% | Canada |
0:02:18 | 2% | Canada |
0:00:27 | 0% | Canada |
0:00:03 | 0% | Canada |
0:01:13 | 1% | Canada |
0:00:01 | 0% | Canada |
0:00:02 | 0% | Canada |
@Anonymous
To make it quick and easy, upload your data on to Power BI and make sure your data is properly organized. Then, show the column names and the expected output
____________________________________
How to paste sample data with your question?
How to get your questions answered quickly?
_____________________________________
Did I answer your question? Mark this post as a solution, this will help others!.
Click on the Thumbs-Up icon on the right if you like this reply 🙂
________________________
Did I answer your question? Mark this post as a solution, this will help others!.
Click on the Thumbs-Up icon on the right if you like this reply 🙂
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
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 |
---|---|
43 | |
23 | |
21 | |
15 | |
15 |
User | Count |
---|---|
46 | |
31 | |
30 | |
18 | |
18 |