Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello.
What is the best way to filter out erroneous data points?
Example data showing a single product's (filtered by a slicer) value over time:
It should look like this (with the erroroneous £185 data point removed):
I can make a calculated column that outputs a high/low/normal flag, but it calculates over the unfiltered table of every product/value.
I don't think I can filter by measures so I don't think I could do something similar with that.
I can't just filter all data that goes above £100 for all products as the (correct) values of different product varies more widely than that.
I can filter the data manually but this isn't as easy for end users.
Here is an example table:
Product Value A £9.30 A £9.91 A £9.12
A £185.85 B £31.25 B £31.29
B £0.031 B £31.32
C £0.52
C £0.51
C £0.53
C £0.50
Is there a way to make a calculated column that removes outliers for each product separately, within this table? (or better ways of doing a similar task)
Many thanks.
This appears to be a duplicate post:
https://community.powerbi.com/t5/Desktop/Dynamically-filtering-erroneous-data/m-p/187913
Proud to be a Super User!
User | Count |
---|---|
92 | |
85 | |
76 | |
66 | |
62 |
User | Count |
---|---|
110 | |
96 | |
95 | |
64 | |
57 |