Default behavior for calculation groups

[AlB]

Hi all,

Imagine you are applying a column in a calculation group as a filter to a visual. The calculation group has two items A1 and A2.

What is the expected behavior if no value is selected in the calculation filter, or if both are selected at the same time? Which of A1 or A2 will be executed?

Many thanks

[hnguy71]

So there's something called ordinance and there's also something called precedence.

Ordinance is the index in which your value is displayed in your slicer or filter, which isn't something we need to currently consider. However, precedence is the order in which the calculation group(s) executes the expression(s).

Let's say if you have two calculation groups active at the same time, the one with the higher precedence is applied or executed first, then the lower one(s). If you're in tabular view, the one that's at the top hierarchy is usually the one with the higher precedence. When everything is in one calculation group, there's no precedence therefore there's no determination on which one gets executed first. 

Hope that helps!

[AlB]

if more than one is selected, is there not a priority mechanism to determine  which will be executed?

Thanks

[hnguy71]

Hi @AlB ,

If none is selected, then no calculation should occur (or shouldn't since I believe it's looking for the SEELECTEDMEAASURE() which isn't found). I also believe the opposite to be true as well as you have multiple "measures" selected.