Different measures with different values in different charts

[andreiasanz]

Hi!

I have a issue in my dashboard that I don't have no ideia why is going on...

I have 2 measures that in KPI chart have VALUE1 and VALUE2 but when I use this measures in Bar chart, the both measures assume the same value VALUE1 (for example). It's a problem of the chart or a problem with dax function (is stranger to be the function)?

I need to have this measures in bar chart but with correct values and with different bar size.

Someone can help me?

Best Regards,

Andreia Sanz

[Phil_Seamark]

Hi @andreiasanz

What are the calculations you are using for your two measures?

[andreiasanz]

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