Measuring table

Question

Hello,I have created a table of measures.Below is the table obtained:Type = VAR OriginalData = ADDCOLUMNS(&nbsp; &nbsp; DISTINCT(BD[Type]);&nbsp; &nbsp; "Index"; 1)VAR NewRow = DATATABLE(&nbsp; &nbsp; "Type"; STRING;&nbsp; &nbsp; "Index"; INTEGER;&nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {"Durée"; 2};&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {"Total intervention"; 3} &nbsp; &nbsp; })VAR CombinedData = UNION(OriginalData; NewRow)RETURN&nbsp; &nbsp; SELECTCOLUMNS(&nbsp; &nbsp; &nbsp; &nbsp; CombinedData;&nbsp; &nbsp; &nbsp; &nbsp; "Type"; [Type];&nbsp; &nbsp; &nbsp; &nbsp; "Index"; [Index])Each column is presented with the following (the measurements are identical, only what is in bold changes)!:40 =&nbsp; &nbsp; var _Bat = "40"&nbsp; &nbsp; // var _Time = MONTH(NOW()) - 1&nbsp; &nbsp; var _Month = [Num_Mois]&nbsp; &nbsp; var _Year = YEAR(NOW())&nbsp; &nbsp; var _Type = SELECTEDVALUE('Type'[Type])&nbsp; &nbsp; var _Mois = if ([Num_Mois] + 1 = 13;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; [Num_Mois] +1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; )&nbsp; &nbsp; var _An = if ([Num_Mois] + 1 = 13;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; YEAR(NOW()) + 1;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; YEAR(NOW())&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; )&nbsp; &nbsp; var Nb_Interv = COUNTROWS(FILTER(BD;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;BD[Bâtiment] = _Bat &amp;&amp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;BD[Type] = _Type &amp;&amp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;BD[Dt Début R] &gt;= date(_Year;_Month;1) &amp;&amp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;BD[Dt Début R] &lt; date(_An;_Mois;1)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; )&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; )&nbsp; &nbsp; VAR TotalSomme = CALCULATE(&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; SUM(BD[Durée R]);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; BD[Bâtiment] = _Bat &amp;&amp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; BD[Dt Début R] &gt;= DATE(_Year; _Month; 1) &amp;&amp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; BD[Dt Début R] &lt; DATE(_An; _Mois; 1)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; )&nbsp; &nbsp; RETURN&nbsp; &nbsp; IF( _Type = "Durée";&nbsp; &nbsp; &nbsp; &nbsp; TotalSomme;&nbsp; &nbsp; &nbsp; &nbsp; Nb_Interv&nbsp; &nbsp; ) &nbsp;The resulting graph:I had done the same thing in Excel, the table is identical to the one in Power BI but the graph is the one below much more telling:These work well. With the exception of:- It doesn't show up in Power Query - The inverse graph X and Y.How to make the chart look like the one obtained on Excel.How to make the sum of each column, lines 1 to 6 and display it on the "Total" row.Thank you for your feedback.Kind regards.

anonymous · Answer

Hi Bob639&nbsp;,
Based on the description, Power Query is primarily used for data transformation and shaping, and it does not execute DAX measures.
Then, invert the X and Y axis options.

&nbsp;
Best Regards,
Wisdom Wu
If this post&nbsp;helps, then please consider&nbsp;Accept it as the solution&nbsp;to help the other members find it more quickly.

bob639 · Answer

Hello, Thank you for your feedback. Ok for Power Query, for the graph it just inverts the Y scale (below)&nbsp;It's not what I expect, see initial graph.Kind regards.

Forum Discussion

Measuring table

Type =

VAR OriginalData = ADDCOLUMNS(

DISTINCT(BD[Type]);

"Index"; 1

)

VAR NewRow = DATATABLE(

"Type"; STRING;

"Index"; INTEGER;

{

{"Durée"; 2};

{"Total intervention"; 3}

}

)

VAR CombinedData = UNION(OriginalData; NewRow)

RETURN

SELECTCOLUMNS(

CombinedData;

"Type"; [Type];

"Index"; [Index]

)

40 =

var _Bat = "40"

// var _Time = MONTH(NOW()) - 1

var _Month = [Num_Mois]

var _Year = YEAR(NOW())

var _Type = SELECTEDVALUE('Type'[Type])

var _Mois = if ([Num_Mois] + 1 = 13;

1;

[Num_Mois] +1

)

var _An = if ([Num_Mois] + 1 = 13;

YEAR(NOW()) + 1;

YEAR(NOW())

)

var Nb_Interv = COUNTROWS(FILTER(BD;

BD[Bâtiment] = _Bat &&

BD[Type] = _Type &&

BD[Dt Début R] >= date(_Year;_Month;1) &&

BD[Dt Début R] < date(_An;_Mois;1)

)

)

VAR TotalSomme = CALCULATE(

SUM(BD[Durée R]);

BD[Bâtiment] = _Bat &&

BD[Dt Début R] >= DATE(_Year; _Month; 1) &&

BD[Dt Début R] < DATE(_An; _Mois; 1)

)

RETURN

IF( _Type = "Durée";

TotalSomme;

Nb_Interv

)

Combining three CONCATENATEX Measures with results from two Tables

Error: The model doesn't have a measure named Measure on table

Measure

Measure Issue in visual table

DAX Measure