Forum Discussion
Outlier behavior analysis with a given base line
What I would do in that case would be to create a measure for September 2015, something along the lines of:
Baseline = CALCULATE(COUNTROWS(Enrollement),FILTER(Enrollement,YEAR(Enrollment[Date])=2015 && MONTH(Enrollment[Date])=9))
Then, create another measure like:
PercentDifference = COUNTROWS([Enrollment]) / [Baseline]
Plot that in a visual and you will theoretically see outliers. Something along those lines.
I learned more about DAX and coded your suggestion. But it seems COUNTROWS([Enrollment]) / [Baseline] basically returns one number as a percentage. It is not a distribution outlier measurement.
Hi liucpaulpbi,
You don't want a percentage? What's a distribution outlier measurement, could you post an example.
Best Regards,
AngeliaWhat I have in mind is to 'compare the current data distribution behavior with a base line distribution behavior'. For example, the table I provided above has two variables, sys and sv, from March to June. I wonder how to use BI to compare the distribution in June against all previous months (March to May). I purposedly planted a few noises in the values of sys/sv throughout the period but month of June has higher level of such noises. I want to use BI to automatically detect such noises, or discrepancy, in distribution compared with previous months.
I guess I can feed the data to Azure for machine learning. That is, split the data into two, use March-May as training data to create a distribution model, and use June data to test the model for outlier behavior. But I wonder if Power BI can achieve similar result using its capabilities.
