***** 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 th-cam.com/video/ZqIjJxggDos/w-d-xo.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
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!
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.
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
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: th-cam.com/channels/y2rBgj4M1tzK-urTZ28zcA.html
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.
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.
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?
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.
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
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%
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?
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 TH-cam channel so that you don't miss out on any updates pertaining to the Power BI. Happy Learning!!! forum.enterprisedna.co/ th-cam.com/channels/y2rBgj4M1tzK-urTZ28zcA.html
***** 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
th-cam.com/video/ZqIjJxggDos/w-d-xo.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
Definitely a wow!
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!
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.
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
Thanks. Very insightful
Wow.... just love your videos. They are extremely useful and helpful!
That's great, thanks for the feedback
Awesome Sam! Much appreciated
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: th-cam.com/channels/y2rBgj4M1tzK-urTZ28zcA.html
Nice one Sam... really liked it...
Thank you!
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.
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.
Very interesting insight
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?
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.
what is the formula for total sales in this example.
Excellent video! Could the same thing be accomplished with conditional formatting?
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
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%
Hi Rajiv, for help like this check out the Enterprise DNA Support Forum - forum.enterprisedna.co/search?expanded=true&q=Outlier
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?
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 TH-cam channel so that you don't miss out on any updates pertaining to the Power BI.
Happy Learning!!!
forum.enterprisedna.co/
th-cam.com/channels/y2rBgj4M1tzK-urTZ28zcA.html
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
No, due to the logic that in built in you need to use the new measure
what is DAX? which algorithm did you apply to detect outliers?
There's no algorithm, DAX is a formula language in Power BI