Decision Trees in Power BI

Hey freswood Regulate,

I came across this same issue today.

In case you're still looking for a solution, here's what I have figured out so far:

Every time you associate a target variable and select a few input variables, Power BI internally creates a data-table from your original set that contains only the fields you have selected.

It then goes and deletes all duplicate rows.

Assume your original input data is a 5x5 table like:

At this point, you have 60% True, 40% False.

Let's say you set your target and pick only Input D as the input variable.

Your internal data-table being used for the decision tree looks like:

Now, you have 66.67% True, 33.33% False.

Let's say you now use Input C as an additional input variable.
Your new internal data-table for the decision tree looks like:

Following along, you're now at 75% True, 25% False

This explains why the values in your root node keep changing every time you modify the input variables.

I haven't yet been able to figure out a way to make this funny (maybe as designed, but I don't like it) behavior stop.

As a workaround, I'm considering including a variable that is unique for each record. Ideally, the tree should never be splitting on that varaible and it'll ensure that all records of your data are considered, since there won't be any duplicates.

Let me know if this makes sense/works. Cheers!

KK