***** Related Links ***** Deep Dive Into Data Outliers - How To Discover And Analyze In Power BI Using DAX blog.enterprisedna.co/deep-dive-into-data-outliers-how-to-discover-and-analyze-in-power-bi-using-dax/ How To Evaluate Clusters In Your Data Using DAX Technique In Power BI blog.enterprisedna.co/evaluate-clusters-in-your-data-advanced-power-dax-technique/ Creating Dynamic Outlier Trigger Points - Advanced Power BI Analysis Technique kzfaq.info/get/bejne/kNd5na2pzM2on6c.html ***** Related Course Modules ***** Unique Analytical Scenarios portal.enterprisedna.co/p/unique-analytical-scenarios Webinar Series Resources portal.enterprisedna.co/p/enterprise-dna-webinar-series-resources Advanced Data Transformations & Modeling portal.enterprisedna.co/p/advanced-data-transformation-and-modeling ***** Related Support Forums ***** Outliers Help. Can’t See My Non-Outliers On Scatter forum.enterprisedna.co/t/outliers-help-cant-see-my-non-outliers-on-scatter/3874 Outlier Sales TY and Outlier Sales LY forum.enterprisedna.co/t/outlier-sales-ty-and-outlier-sales-ly/3119 Dynamic Grouping Into Quadrants forum.enterprisedna.co/t/dynamic-grouping-into-quadrants/4115 For more outlier detection queries to review see here….. forum.enterprisedna.co/search?q=outlier%20detection
@oladman9058 Жыл бұрын
Definitely a wow!
@EnterpriseDNA Жыл бұрын
Hi oladman, glad that you appreciated our content! If you haven't yet, you can subscribe to our channel to see all our upcoming Power BI and Power Platform video tutorials and announcements. Cheers!
@barttitulaerexcelbart94006 жыл бұрын
Thank you Sam, great explained. Although I did not understand why COUNTROWS was in that long formula, 2x Filter, OK, but Countrows? You could even improve this model by letting the user select the borders of the outliers.
@xp00ch4 жыл бұрын
It's effectively conditional logic for the CALCULATE. If you look closely you can see the > 0 at the end of the formula. So it's counting the rows returned where there are "passes" to the sales and profit criteria, if this is > 0 then it fires the CALCULATE on a row by row basis due to the FILTER ( VALUES
@NirRobinson6 жыл бұрын
Thanks. Very insightful
@nacujo39856 жыл бұрын
Wow.... just love your videos. They are extremely useful and helpful!
@EnterpriseDNA6 жыл бұрын
That's great, thanks for the feedback
@TheTrudyholguin3 жыл бұрын
Awesome Sam! Much appreciated
@EnterpriseDNA3 жыл бұрын
Hi Clamps 2litt, great that you found value in this video. You can subscribe to our channel to see all our upcoming Power BI video tutorials. Here’s the link: kzfaq.info/love/y2rBgj4M1tzK-urTZ28zcA
@Marmit424246 жыл бұрын
Thank you!
@rrrprogram86676 жыл бұрын
Nice one Sam... really liked it...
@vida17196 жыл бұрын
Very interesting insight
@chiggywiggyable5 жыл бұрын
I would like to know the formulas of each new measure you have created because we are trying something similar with our data. These formulas can guide us.
@ackrite556 жыл бұрын
That was amazing! I have invested a week in trying to get R to work behind a locked down network so I could utilize some of it's features. But this approach totally alleviates a headache. Is there a Dax limitation where R could be called upon?
@EnterpriseDNA6 жыл бұрын
I haven't really dived much in R so I can't say definitively, but DAX is incredible and I can find most of the things I've ever needed from an analytical perspective with DAX.
@sara_el.a6 жыл бұрын
For my lab I measured the absorption for 1 sample 5 times (5-10-15-20-25 minutes). I did this for 10 different samples (different concentrations). How do I determine if I have outliners? I already made a regression line where I can clearly see that I do have outliers.
@josephkingston80794 жыл бұрын
Excellent video! Could the same thing be accomplished with conditional formatting?
@EnterpriseDNA4 жыл бұрын
Hi Joseph - With new Power BI Versions, You can achieve this using Conditional Formatting with some custom measures, however you won't get the option to use Slicer. Regards, Enterprise DNA
@chiggywiggyable5 жыл бұрын
what is the formula for total sales in this example.
@rajivgusain57255 жыл бұрын
Hi Sam I have a doubt why did the filter didn't calculate the other rows in the max and min of profit margins and sales in the outlier logic table. For instance when you typed the dax formula of profit margin > outlier logic(profit margin min) here it calculated 35% but not 0%
@EnterpriseDNA5 жыл бұрын
Hi Rajiv, for help like this check out the Enterprise DNA Support Forum - forum.enterprisedna.co/search?expanded=true&q=Outlier
@bengislason88433 жыл бұрын
Any way to do this across a 3rd dimension? I am trying to wrap my head around this for an application where outlier thresholds are different based on another filtering table. I have integrated the filtering table portion but I want to summarize outliers across all fields in filtering table. Any thoughts out there?
@EnterpriseDNA3 жыл бұрын
Hello Ben Gislason, thank you for posting your query onto our channel. Well it's always a little bit difficult to judge and provide the results without looking at the data structure, model and working of the PBIX file for the reference. And therefore we encourage you to please write back to us onto our Community Forum by providing the proper description of the problem that you're facing along with the PBIX file for the reference as well as the mock-up results that you're trying to achieve 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. Hoping you find this useful. Also make sure that you're subscribed to our KZfaq channel so that you don't miss out on any updates pertaining to the Power BI. Happy Learning!!! forum.enterprisedna.co/ kzfaq.info/love/y2rBgj4M1tzK-urTZ28zcA
@hoanguyenfutu6 жыл бұрын
what is DAX? which algorithm did you apply to detect outliers?
@EnterpriseDNA6 жыл бұрын
There's no algorithm, DAX is a formula language in Power BI
@rrrprogram86676 жыл бұрын
Why do we need to have "Sales Grouping" on the Y-Axis.... can we just have normal "Total Sales" on the y-axis ?? and get the same result
@EnterpriseDNA6 жыл бұрын
No, due to the logic that in built in you need to use the new measure