Forum Discussion
Problem with Reference Line when trying to update filters
Hi there, I'm new to BI, and I would like to know, if there is a way to correct the problem with two references lines in graphic bars. I have two lines and when I click on the date to filter, in ...
Hi dicarva
Can you try this?
MedidaMeta =
VAR _Result =
CALCULATE(
AVERAGEX(
FILTER(
CenariosIDE,
CenariosIDE[Estado] = TRUE &&
CenariosIDE[Descricao] = "Meta"
),
CenariosIDE[Valor]
),
USERELATIONSHIP(CenariosIDE[Ano], Calendar[Ano])
)
RETURN
If( _Result > 0, _Result, Blank() )