SWITCH(True()) Measure Incorrectly Categorizing due to overlapping '&&' conditions

[Anonymous]

Hi All,

I am using the following measure to bucket movement between two scores overtime under a few categories

However by the looks of results, my categories seem to bucket these criteria all over the place. Following are my actual results (on top) Vs. my calculation on excel. (bottom)

(The totals seem to be correct at 994 each)

Please help me correct this bucketing measure. Thanks

[I am only getting the spill or the "NA" category correcty (which is embarassing)

I am comparing, conditioning the following criteria in the measure:

the Start Date and End dates

the Score at Start Date and End Date

The score (scored out of 4)]

[MFelix]

Hi @Anonymous ,

To what I can understand you are calculating the count of values for each bucket being the bucket created by a measure is this correct?

Be aware that measures are context sensitive so when the context changes the calculations change has you can see no the last column that you have a Moved Up bucket (in theory on the total line the bucket should not exist).

can you share a sample file?

[Anonymous · Accepted solution]

Hi All,

I was able to think through and find a way to correctly bucket my data. Turns out my data buckets needed to be defined more presicsely. ALLSELECTED was a lifesaver for me to work with my time ranges. following is the corrected version of my Select TRUE function. Hope this helps, 

Thanks