Forum Discussion
Different measures with different values in different charts
Hi Phil_Seamark
Thanks for your attention.
This is measure 1:
COUNTROWS(
VAR request_autoP =
CALCULATETABLE ( VALUES ( TABELA_3[REQUEST_ID] );
TABELA_3[ACTION_NAME] = "PING")
VAR object_assoc_autoP =
CALCULATETABLE (
VALUES ( TABELA_2[REQUEST_OBJECT_ID] );
TREATAS ( request_autoP; TABELA_2[REQUEST_ID] )
)
RETURN
CALCULATETABLE (
TABELA_1;
TREATAS ( object_assoc_autoP; TABELA_1[REQUEST_OBJECT_ID] )
)
)
This is mesure 2:
COUNTROWS(
VAR request_UM =
CALCULATETABLE ( VALUES ( TABELA_3[REQUEST_ID] );
TABELA_3[origin] = "WF_ORIGIN";
TABELA_3[ACTION_NAME] = "UNRESTORED_PING"
)
VAR object_assoc_UM =
CALCULATETABLE (
VALUES ( TABELA_2[REQUEST_OBJECT_ID] );
TREATAS ( request_UM; TABELA_2[REQUEST_ID] )
)
RETURN
CALCULATETABLE (
TABELA_1;
TREATAS ( object_assoc_UM; TABELA_1[REQUEST_OBJECT_ID] )
)
)
This two measures on Card Chart (KPI) have the following values: 8360 and 19030.
When a put this measures on Bar Chart, both measures have the same value (8360).
Best Regards,
Andreia Sanz