Finding Disproportionate Outliers With DAX

Rob Collie uses DAX to find disproportionate sentiment on a per-group basis:

My wife loves to travel AND she loves data, so it’s no surprise that she showed me the infographic in question.

“Oh come on, California residents don’t visit the Philippines more often than any other country.”  That was my first reaction.  (Mexico is the overwhelming #1 destination, basically for every state… because Cancun.  And because there are so many Mexican-Americans).

“Ah…  but California residents DO visit the Philippines disproportionately more often than they ‘should,’ according to national averages!”  That was my dawning second realization (and confirmed by the fine print of the Orbitz article, even though the article’s title suggests otherwise.)

So, how do we do that in DAX?  Pretty simply, actually.

I’m mentally working out whether this could be useful in anomaly detection.

Related Posts

Jitter In Power BI Charts

Rob Collie shows how to incorporate jitter in Power BI scatter charts: Now, sometimes you may WANT multiple rows to combine into one dot, but in this particular case, I want to see each row of my source data as its own dot. When adding a new calculated column, there are LOTS of ways to uniquely […]

Read More

Power BI Image Timeline

Devin Knight continues his Power BI custom visuals series: In this module you will learn how to use the Image Timeline Custom Visual.  The Image Timeline is a great way to display data in order across a timeline.  If you have images of your data you can also display those images on the timeline. This […]

Read More

Categories

February 2017
MTWTFSS
« Jan Mar »
 12345
6789101112
13141516171819
20212223242526
2728