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 ...
Thank you for answer.
I will share the graph and the measures for a better understand.
This is the correct graphc aspect:
Then when I clicked in the filter this happens:
The first measure:
MedidaByPass = CALCULATE(
AVERAGEX(
FILTER(
CenariosIDE,
CenariosIDE[Estado] = TRUE &&
CenariosIDE[Descricao] = "CER Bypass"
),
CenariosIDE[Valor]
),
USERELATIONSHIP(CenariosIDE[Ano], Calendar[Ano])
)
Another measure:
Another measure:
MedidaMeta =
CALCULATE(
AVERAGEX(
FILTER(
CenariosIDE,
CenariosIDE[Estado] = TRUE &&
CenariosIDE[Descricao] = "Meta"
),
CenariosIDE[Valor]
),
USERELATIONSHIP(CenariosIDE[Ano], Calendar[Ano])
)
I'm sorry because my Bi is in Portuguese.
I hope this can help you to understand.
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() )