Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
100 | |
75 | |
73 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |