Hi Damien, 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!
Great video!! If I may... I think it would be more efficient if you indicate in the Outlier Sales measure, in an explicit way a "MAX": [Total Sales] >= MAX('Outliers Detection Logic'[Total Sales min]). And a MIN in the Non Outlier... Then the measure would only calculate the Total Sales for the Customers needed.
Hi Alvaro, glad that you appreciated our content! Thanks for sharing your top as well! 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!
Hi Rajarshi, 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!
Great content! However, I have a few questions: 1. at 6:16, will it make a difference if I choose a different column name for the `Customers` table instead of customer name? (e.g., VALUES(Customers[Customer ID])). what i mean by "make a difference" is this: when I hover over each scatter point now, will the tooltip display the customer ID instead of the customer name? also, isn't it more accurate to use ID, since there's a rare chance that names are duplicated? 2. `Total Sales` column is found in the `Sales` table which is implicitly related to the `Customers` table via the `VALUES(Customers[Customer Name]) expression, correct? 3. at 8:55, from what I understand, `Sales Grouping` measure is evaluated for each data point in the scatter chart. If that's the case, then for each of these points, how does SELECTEDVALUE() function correctly evaluate to `Outlier` or `Non-Outlier`, given that the `Outlier Detection Logic` table is a detached table (i.e., not connected to `Sales` or `Customers` tables)?
![The DATEADD Function - The Best and Most Versatile Time Intelligence Function In DAX [2022 Update]](http://i.ytimg.com/vi/N-77CnEWe0I/mqdefault.jpg)
![The DATEADD Function - The Best and Most Versatile Time Intelligence Function In DAX [2022 Update]](/img/tr.png)
Check out our FREE courses: bit.ly/3N00AJw
In statistics, data points that fall beyond 3 standard deviations (3rd stdev) from the mean are often considered outliers.
Great video as always Sam. :) Love the work you and the guys at EDNA are doing
Hi Damien, 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!
Great video!!
If I may... I think it would be more efficient if you indicate in the Outlier Sales measure, in an explicit way a "MAX": [Total Sales] >= MAX('Outliers Detection Logic'[Total Sales min]).
And a MIN in the Non Outlier...
Then the measure would only calculate the Total Sales for the Customers needed.
Hi Alvaro, glad that you appreciated our content! Thanks for sharing your top as well! 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!
Pretty cool, will implement it right away. 😋
Hi Rajarshi, 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!
Great content! However, I have a few questions:
1. at 6:16, will it make a difference if I choose a different column name for the `Customers` table instead of customer name? (e.g., VALUES(Customers[Customer ID])).
what i mean by "make a difference" is this:
when I hover over each scatter point now, will the tooltip display the customer ID instead of the customer name? also, isn't it more accurate to use ID, since there's a rare chance that names are duplicated?
2. `Total Sales` column is found in the `Sales` table which is implicitly related to the `Customers` table via the `VALUES(Customers[Customer Name]) expression, correct?
3. at 8:55, from what I understand, `Sales Grouping` measure is evaluated for each data point in the scatter chart. If that's the case, then for each of these points, how does SELECTEDVALUE() function correctly evaluate to `Outlier` or `Non-Outlier`, given that the `Outlier Detection Logic` table is a detached table (i.e., not connected to `Sales` or `Customers` tables)?
🎉🎉🎉🎉🎉😮
Thanks for the continued support, autobase16!
Really not an outlier from a statistical standpoint