Forum Discussion

andreiasanz's avatar
andreiasanz
Frequent Visitor
8 years ago

Different measures with different values in different charts

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

Need Help

2 Replies

    • andreiasanz's avatar
      andreiasanz
      Frequent Visitor
      8 years ago

      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