Forum Discussion
How to create an input object and a variable?
Anonymous
Its seems you have a Secondary Y-Axis for the line (its on the right side of the chart in the second picture you posted)
You have to turn it off if you want the line to stay above!
I loaded the tables but I did not find a way to relate them to the .xls data and even then I'm trying to adapt the following measure to the table that has the% information, but I'm not getting any tips
Meta Liquidação2 =
SUMX (
FILTER ( ALL ( Fatos ); Fatos[Ano_ID] = MAX ( Fatos[Ano_ID] ) - 1 );
Fatos[Vl_Liquidado] - Fatos[Vl_Devolvido]
+ Fatos[Vl_DevolucaoCancelada]
- Fatos[Vl_LiquidacaoCancelada]
* (TabelaMeta[%]))
Anonymous
TabelaMeta should not be related to any other table! Then create a Slicer with the TabelaMeta[%] column
in the Measure below you'll multiply times the other column TabelaMeta[%Valor]
So if anything in the Slicer is selected - you'll multiply the result of SUMX times the value selected in the Slicer
if nothing is selected you'll just get the result of SUMX
Meta Liquidação2 =
IF (
HASONEVALUE ( TabelaMeta[%] );
SUMX (
FILTER ( ALL ( Fatos ); Fatos[Ano_ID] = MAX ( Fatos[Ano_ID] ) - 1 );
Fatos[Vl_Liquidado] - Fatos[Vl_Devolvido]
+ Fatos[Vl_DevolucaoCancelada]
- Fatos[Vl_LiquidacaoCancelada]
)
* VALUES ( TabelaMeta[%Valor] ); // this will only calculate the %
SUMX (
FILTER ( ALL ( Fatos ); Fatos[Ano_ID] = MAX ( Fatos[Ano_ID] ) - 1 );
Fatos[Vl_Liquidado] - Fatos[Vl_Devolvido]
+ Fatos[Vl_DevolucaoCancelada]
- Fatos[Vl_LiquidacaoCancelada]
)
)
You may have to adjust this part
* VALUES ( TabelaMeta[%Valor] ); <= calculates only the %
* ( 1 - VALUES ( TabelaMeta[%Valor] ) ); <= discount applied
* ( 1 + VALUES ( TabelaMeta[%Valor] ) ); <= premium added
Hope this helps! :smileyhappy:
Anonymous
Its seems you have a Secondary Y-Axis for the line (its on the right side of the chart in the second picture you posted)
You have to turn it off if you want the line to stay above!
Thanks for the help, it worked, but only one error occurs when I select the values of 20% or more, the graph line is below the real value, and it should stay above as the other values of 15% or less, the Non-graphic value when selected is correct but the line display is incorrect.