Forum Discussion
DAX Measure from Excel Formula
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('S...
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 , 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 |