Forum Discussion
Decomposition Tree Color Coding
Hi 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.
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.