cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
andreiasanz Frequent Visitor
Frequent Visitor

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

2 REPLIES 2
Microsoft Phil_Seamark
Microsoft

Re: Different measures with different values in different charts

Hi @andreiasanz

 

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


To learn more about DAX visit : aka.ms/practicalDAX

Proud to be a Datanaut!

andreiasanz Frequent Visitor
Frequent Visitor

Re: 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

Helpful resources

Announcements
Exclusive LIVE Community Event #3 – Ask Arun Anything

Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

January 2020 Community Highlights

January 2020 Community Highlights

Make sure you didn't miss any of the things that happened in the community in January!

Top Solution Authors