- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
How to identify outliers values in DAX? Follow example bellow
Cod | Price | Outlier |
300-0001-10 | 15000,00 | Yes |
300-0001-10 | 1,98 | no |
300-0001-10 | 2,00 | no |
300-0001-10 | 1,98 | no |
300-0002-11 | 1500 | no |
300-0002-11 | 1500 | no |
300-0002-11 | 0,01 | yes |
I need a DAX that show the outlier for each Cod number as example below. Second step is to show the status of the Outlier with "Yes" or "no". Thanks!

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
here is a real example of my database, here we have two outliers, one with 216k and other 28k, both are outliers.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
First of all, I'm glad you were so quick to help me.
Actually it would be the standard deviation I need. I put a few examples to facilitate understanding. To exemplify my need, imagine that in thousands of items, some items have very high or very low prices, but not all. So I need to find the standard deviation for the cases and delete them from the database.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
@Anonymous , sorry, I am not sure what is your criteria for deviation, how do you define or measure the ourlier.
Maybe wait for other people to help. 😀

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Sorry! Indeed, the columns came together. I attached an image for better viewing. please someone help me.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
@Anonymous , seems you want to find the min and max of price, please see below measure and pbix file attached as well.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
@Anonymous not sure what is your criteria for the outlier of Cod number, is it the length of Cod column or min/max price for Cod column, also for the example data, there is no vertical line or space to seperate Cod and Price column, it is no possible to identify the data in both columns
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hello! In the "cod."column I have two examples of the alot others: 300-0001-10 and 300-002-11. these two codes represent products with their respective prices and within each code I need to identify and show the Outliers. As the image bellow.

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
04-04-2024 09:31 PM | |||
09-06-2024 04:51 AM | |||
03-25-2024 05:57 AM | |||
08-19-2024 08:47 AM | |||
03-26-2024 11:37 AM |
User | Count |
---|---|
14 | |
14 | |
11 | |
11 | |
8 |