Forum Discussion
Decomposition Tree Color Coding
Community SupportHi Anonymous ,
After digging, I find the error is occured because if A is "NO" and B is "NO", then all values for C is "YES".
In this way, the measure will not analyze to the next level "B", all values suit the condition
A roughly but effective solution is add a row in the data source, A is "NO" and B is "NO" and C is "NO", but the count column is 0. I create a new sample to test and get the correct result:
I attach my sample below for your reference.
Best Regards,
Community Support Team _ kalyj
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Is there any other option? I was using simplified data due to privacy concerns. However, instead of 'YES' or 'NO', there are actually 5 options per category. There are 5 categories total, so the number of permutations grows quite fast, and I'm not sure this option is feasible. Is there a better way to assign conditional formatting or a quicker workaround to the solution you described?
Just following up again - is there any solution that doesn't require listing out all possible permutations? My data has 5 selections in each field, and there is 6 fields. 5^6 = 15625, which is largely impractical to list out for this data.