***** Learning Power BI? ***** FREE COURSE - Ultimate Beginners Guide To Power BI - portal.enterprisedna.co/p/ultimate-beginners-guide-to-power-bi FREE COURSE - Ultimate Beginners Guide To DAX - portal.enterprisedna.co/p/ultimate-beginners-guide-to-dax FREE - 60 Page DAX Reference Guide Download - enterprisedna.co/dax-formula-reference-guide-download FREE - Power BI Resources - enterprisedna.co/power-bi-resources Enterprise DNA Membership - enterprisedna.co/membership Enterprise DNA Online - portal.enterprisedna.co/ Enterprise DNA Events - enterprisedna.co/enterprise-dna-events-page/ ***** Related Links ***** New Customer Analysis Using Advanced DAX - blog.enterprisedna.co/calculate-the-total-of-new-clients-youre-onboarding-every-month-advanced-dax/ Time Intelligence In Power BI: How to Calculate The Number of Transactions Made in the Last N Days - blog.enterprisedna.co/how-to-calculate-the-number-of-transactions-made-in-last-n-days-power-bi-using-dax/ Power BI Advanced Analytics: Secondary Table Logic Techniques - blog.enterprisedna.co/secondary-table-logic-inside-of-power-bi-using-dax/ ***** Related Course Modules ***** Mastering DAX Calculations - portal.enterprisedna.co/p/mastering-dax-calculations Business Analytics Series - portal.enterprisedna.co/p/business-analytics-series DAX Formula Deep Dives - portal.enterprisedna.co/p/dax-formula-deep-dives ***** Related Support Forum Posts ***** Using COUNTROWS But Also Managing Many Filters - DAX Formula Optimization - forum.enterprisedna.co/t/using-countrows-but-also-managing-many-filters-dax-formula-optimization/2922 Loyalty Tracking - forum.enterprisedna.co/t/loyalty-tracking/5341 If Is Blank In Countrows Card Visual - forum.enterprisedna.co/t/if-is-blank-in-countrows-card-visual/5179 For more COUNTROWS support queries to review see here - forum.enterprisedna.co/search?q=countrows
Hi Georg, glad that you appreciated our content! If you haven't yet, you can subscribe to our channel to see all our upcoming Power BI video tutorials. Cheers!
Hi Sam, thanks for another video, always looking forward to "stealing" ideas from you. It took me a bit to wrap my head around this one, still juggling it, but I am starting to see the logic behind it--this has to do with Orders and Revenue for me being two distinct tables, but here it is the same one.
Hi Sam, High quality content and good overview indeed! One question related your formula behind the chart at top right (9:00): Why do you need values(customers [customer names]) in the second filter parameter of the calculate? What that part does? Thanks in advance for your answer. Tamas
It incorporates the customer in the filter context other wise all the visual will show the same total ie the sum of all top 50 customer since we have removed the filter context using all.
Hi Sam. Great content, as always. One small thing, is there a way to feed inputs from Power BI to Excel. We can take numbers from Excel and use them in Power BI but can it be done the other way round also?
Hi Kristina Melnichenko, glad you appreciated the video. You can subscribe to our channel to see all our upcoming Power BI video tutorials. Here’s the link: th-cam.com/channels/y2rBgj4M1tzK-urTZ28zcA.html
Hi Arden, Thank you for posting your query onto our channel. We really appreciate you taking your valuable time to post it. Well, for your information, there's no function called as "COUNTIF()" in Power BI. So we're not sure why you're asking for a difference? For furthermore queries, you can also reach out to us onto our Community Forum where our members as well as experts team will be able to assist you in a better and efficient manner. Below is the link of the forum provided for the reference as well. Hoping you find this useful. Also, make sure that you're subscribed to our TH-cam channel so that you don't miss out on any updates pertaining to the Power BI. You can also join our Power BI group on LinkedIn to receive latest updates on Power BI. Below are the links provided for the reference purposes. Cheers, Enterprise DNA forum.enterprisedna.co/ th-cam.com/channels/y2rBgj4M1tzK-urTZ28zcA.html www.linkedin.com/groups/12004506/
Hello Stefan Singh, thank you for posting your query onto our channel. One way to achieve this is, you can make use of parameters rather than substituting static numbers. We're providing few of the links of the articles from our blog posts as well as links of the videos from our Enterprise DNA TH-cam channel pertaining to this topic. For furthermore queries, you can also reach out to us onto our Community Forum where our members as well as experts team will be able to assist you in a better and efficient manner. Below is the link of the forum provided for the reference as well. Hoping you find this useful and meets your requirements that you've been looking for. Happy Learning!!! forum.enterprisedna.co/ medium.com/@sam.mckay/learn-how-to-use-multiple-what-if-parameters-advanced-dax-60811f7e55c4 community.powerbi.com/t5/Community-Blog/What-If-Analysis-Techniques-For-Power-BI/ba-p/460414 blog.enterprisedna.co/using-what-if-parameters-in-power-bi/ blog.enterprisedna.co/multiple-what-if-parameter-handling-in-power-bi/ th-cam.com/video/7IEYHMvqZHY/w-d-xo.html th-cam.com/video/tsXjeZ2rL0c/w-d-xo.html th-cam.com/video/ol-d1T04vvc/w-d-xo.html
***** Learning Power BI? *****
FREE COURSE - Ultimate Beginners Guide To Power BI - portal.enterprisedna.co/p/ultimate-beginners-guide-to-power-bi
FREE COURSE - Ultimate Beginners Guide To DAX - portal.enterprisedna.co/p/ultimate-beginners-guide-to-dax
FREE - 60 Page DAX Reference Guide Download - enterprisedna.co/dax-formula-reference-guide-download
FREE - Power BI Resources - enterprisedna.co/power-bi-resources
Enterprise DNA Membership - enterprisedna.co/membership
Enterprise DNA Online - portal.enterprisedna.co/
Enterprise DNA Events - enterprisedna.co/enterprise-dna-events-page/
***** Related Links *****
New Customer Analysis Using Advanced DAX - blog.enterprisedna.co/calculate-the-total-of-new-clients-youre-onboarding-every-month-advanced-dax/
Time Intelligence In Power BI: How to Calculate The Number of Transactions Made in the Last N Days - blog.enterprisedna.co/how-to-calculate-the-number-of-transactions-made-in-last-n-days-power-bi-using-dax/
Power BI Advanced Analytics: Secondary Table Logic Techniques - blog.enterprisedna.co/secondary-table-logic-inside-of-power-bi-using-dax/
***** Related Course Modules *****
Mastering DAX Calculations - portal.enterprisedna.co/p/mastering-dax-calculations
Business Analytics Series - portal.enterprisedna.co/p/business-analytics-series
DAX Formula Deep Dives - portal.enterprisedna.co/p/dax-formula-deep-dives
***** Related Support Forum Posts *****
Using COUNTROWS But Also Managing Many Filters - DAX Formula Optimization - forum.enterprisedna.co/t/using-countrows-but-also-managing-many-filters-dax-formula-optimization/2922
Loyalty Tracking - forum.enterprisedna.co/t/loyalty-tracking/5341
If Is Blank In Countrows Card Visual - forum.enterprisedna.co/t/if-is-blank-in-countrows-card-visual/5179
For more COUNTROWS support queries to review see here - forum.enterprisedna.co/search?q=countrows
You have the best Power BI content and teaching style! 1000 times worth the MS docs.
Hi Georg, glad that you appreciated our content! If you haven't yet, you can subscribe to our channel to see all our upcoming Power BI video tutorials. Cheers!
Thanks Sam for the great videos you providing us with. well detailed, clear and very helpful. Two thumbs up!
Hi Sam, thanks for another video, always looking forward to "stealing" ideas from you.
It took me a bit to wrap my head around this one, still juggling it, but I am starting to see the logic behind it--this has to do with Orders and Revenue for me being two distinct tables, but here it is the same one.
Another great video! A big thanks from your fans in New York!
Hi Sam,
High quality content and good overview indeed!
One question related your formula behind the chart at top right (9:00): Why do you need values(customers [customer names]) in the second filter parameter of the calculate? What that part does?
Thanks in advance for your answer.
Tamas
It incorporates the customer in the filter context other wise all the visual will show the same total ie the sum of all top 50 customer since we have removed the filter context using all.
How to make TOPN 50 as dynamic, allowing user to select TOPN 30 or TOPN 10?
Hi Sam. Great content, as always.
One small thing, is there a way to feed inputs from Power BI to Excel. We can take numbers from Excel and use them in Power BI but can it be done the other way round also?
@sainyam kumar U can do it with copy table at the where the table lies after import or export the visual if u want the report data
Very good thank you!
Hi Kristina Melnichenko, glad you appreciated the video. You can subscribe to our channel to see all our upcoming Power BI video tutorials.
Here’s the link: th-cam.com/channels/y2rBgj4M1tzK-urTZ28zcA.html
What’s the diff between using this vs countif?
Hi Arden,
Thank you for posting your query onto our channel. We really appreciate you taking your valuable time to post it.
Well, for your information, there's no function called as "COUNTIF()" in Power BI. So we're not sure why you're asking for a difference?
For furthermore queries, you can also reach out to us onto our Community Forum where our members as well as experts team will be able to assist you in a better and efficient manner. Below is the link of the forum provided for the reference as well.
Hoping you find this useful. Also, make sure that you're subscribed to our TH-cam channel so that you don't miss out on any updates pertaining to the Power BI. You can also join our Power BI group on LinkedIn to receive latest updates on Power BI. Below are the links provided for the reference purposes.
Cheers,
Enterprise DNA
forum.enterprisedna.co/
th-cam.com/channels/y2rBgj4M1tzK-urTZ28zcA.html
www.linkedin.com/groups/12004506/
Great video!
In the first example, how do I make it dynamic so that it can adjust to filters?
Hello Stefan Singh,
thank you for posting your query onto our channel.
One way to achieve this is, you can make use of parameters rather than substituting static numbers. We're providing few of the links of the articles from our blog posts as well as links of the videos from our Enterprise DNA TH-cam channel pertaining to this topic.
For furthermore queries, you can also reach out to us onto our Community Forum where our members as well as experts team will be able to assist you in a better and efficient manner. Below is the link of the forum provided for the reference as well.
Hoping you find this useful and meets your requirements that you've been looking for.
Happy Learning!!!
forum.enterprisedna.co/
medium.com/@sam.mckay/learn-how-to-use-multiple-what-if-parameters-advanced-dax-60811f7e55c4
community.powerbi.com/t5/Community-Blog/What-If-Analysis-Techniques-For-Power-BI/ba-p/460414
blog.enterprisedna.co/using-what-if-parameters-in-power-bi/
blog.enterprisedna.co/multiple-what-if-parameter-handling-in-power-bi/
th-cam.com/video/7IEYHMvqZHY/w-d-xo.html
th-cam.com/video/tsXjeZ2rL0c/w-d-xo.html
th-cam.com/video/ol-d1T04vvc/w-d-xo.html
How I can create the sensitive date as the one above??
Great!!!