Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Solved! Go to Solution.
hi,
the syntax:
CALCULATE ( <Expression> [, <Filter> [, <Filter> [, … ] ] ] )
treat Filter1, Filter2 with the AND operations.
to use the OR operations, you need to use it within the same filter.
testcalculate = VAR ano = FORMAT ( YEAR ( MAX ( FatoOpex[Data] ) ) - 3; "####" ) RETURN CALCULATE ( SUM ( FatoOpex[valor] ); FILTER(FatoOpex;
OR ( FatoOpex[exDiretoria] = "0" && FatoOpex[DimCalendario.Ano] = ano; FatoOpex[exDiretoria] = "1" && FatoOpex[DimNatureza.idNatureza] = "7" && FatoOpex[DimCalendario.Ano] = ano ) )
Give this a try
testcalculate = VAR ano = FORMAT ( YEAR ( MAX ( FatoOpex[Data] ) ) - 3; "####" ) RETURN CALCULATE ( SUM ( FatoOpex[valor] ); OR ( FatoOpex[exDiretoria] = "0" && FatoOpex[DimCalendario.Ano] = ano; FatoOpex[exDiretoria] = "1" && FatoOpex[DimNatureza.idNatureza] = "7" && FatoOpex[DimCalendario.Ano] = ano ) )
thank you for your try, but have this :
"The expression contains multiple columns, but only a single column can be used in a True/False expression that is used as a table filter expression."
hi,
the syntax:
CALCULATE ( <Expression> [, <Filter> [, <Filter> [, … ] ] ] )
treat Filter1, Filter2 with the AND operations.
to use the OR operations, you need to use it within the same filter.
testcalculate = VAR ano = FORMAT ( YEAR ( MAX ( FatoOpex[Data] ) ) - 3; "####" ) RETURN CALCULATE ( SUM ( FatoOpex[valor] ); FILTER(FatoOpex;
OR ( FatoOpex[exDiretoria] = "0" && FatoOpex[DimCalendario.Ano] = ano; FatoOpex[exDiretoria] = "1" && FatoOpex[DimNatureza.idNatureza] = "7" && FatoOpex[DimCalendario.Ano] = ano ) )
thank you ! it worked fine!
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
120 | |
101 | |
71 | |
61 |