Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Solved! Go to Solution.
As the error message said, in CALCULATE() function, the second parameter can be a True/False expression. You need to put a filted table context. So your formula should be like:
NCS = CALCULATE ( SUM ( 'GA-Adwords Table'[Ad Spend (EUR)] ), FILTER ( 'GA-Adwords Table', [ROAS] < 1 ) )
Regards,
I have this error:
"RUBRO_C16",IF(VALOR_SALUD_COL_IND[COD RAMO CONT FINAL] IN {"045","034"},CALCULATE(SUM(VALOR_SALUD_COL_IND[VALOR_CALCULADO]),
FILTER(VALOR_SALUD_COL_IND,VALOR_SALUD_COL_IND[COD RUBRO FINAL] = "C16" )),
CALCULATE((SUM(VALOR_SALUD_COL_IND[VALOR_CALCULADO])),
FILTER(VALOR_SALUD_COL_IND,VALOR_SALUD_COL_IND[COD RUBRO FINAL] = "C16" ))),
The True/False expression does not specify a column. Each True/False expressions used as a table filter expression must refer to exactly one column.
As the error message said, in CALCULATE() function, the second parameter can be a True/False expression. You need to put a filted table context. So your formula should be like:
NCS = CALCULATE ( SUM ( 'GA-Adwords Table'[Ad Spend (EUR)] ), FILTER ( 'GA-Adwords Table', [ROAS] < 1 ) )
Regards,
This solved my problem! thank you kindly!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
115 | |
99 | |
88 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |