topic Re: DAX Measure from Excel Formula in DAX Commands and Tips

DAX Measure from Excel Formula

Anonymous — Mon, 10 Aug 2020 10:27:14 GMT

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)

Re: DAX Measure from Excel Formula

Fowmy — Mon, 10 Aug 2020 10:34:57 GMT

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 🙂

YouTube, LinkedIn

________________________

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 🙂

YouTube, LinkedIn

Re: DAX Measure from Excel Formula

amitchandak — Mon, 10 Aug 2020 10:46:50 GMT

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?

Re: DAX Measure from Excel Formula

Greg_Deckler — Mon, 10 Aug 2020 11:53:36 GMT

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.

Re: DAX Measure from Excel Formula

Anonymous — Mon, 10 Aug 2020 13:24:53 GMT

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