Variables are to be considered constants even when they contain a table. In your Black4_Version2 measure, the CALCULATE() doesn't change the COUNTROWS(B) result, since it's counting the rows of a constant table and no filtering is happening.
Black4_Version2 =
VAR B =
FILTER(
Table,
Condition2 = "Black"
)
RETURN
CALCULATE(
COUNTROWS( B ),
Condition1 = 4
)
but you can iterate over a constant table, therefore FILTER works
Black4_Version3 =
VAR B =
FILTER(
Table,
Condition2 = "Black"
)
RETURN
COUNTROWS(
FILTER(
B,
Condition1 = 4
)
)
P.S. I used the pseudo-DAX sintax used in the answer, since instead of Condition1 = 4 a column reference like Table[Column1] = 4 should be used
so a good rule of thumb is that vaariables: - can be used to create filtered tables, which then can be used to be iterated over in return statement (so to create a Filter part of the CALCULATE statement) - cannot be used to replace Expression over which a Filter is applied later, because the Filter will not work even if you use CALCULATE? @sergiom
Correct, also variables can be used as filter arguments in calculate expression.
so if I understand it correctly, I could write a calculation where I 1st calculate a variable that gives a filtered table (using FILTER), then in same calculation write a 2nd variable that also uses FILTER using the result from 1st var instead of Table. and then write a return statement where I can write an expression that is iterated over the Table that results from Var2?
yes.maybe there are more efficient solutions, but it would work
thank you, I think that I understand now (well, maybe not understand, but I now have a rule that I can learn from the top of my head and hopefully the understanding will follow with practice)