Combined graph doesnt calculated graph line

Question

I need to create a combined graph with two columns and a percentage line.But when I select two filters from the same column, the graph line is not recalculating the percentage, it only shows the result as average, sum, standard deviation and others.&nbsp;Is there any solution for this?&nbsp;Example: SlicersData1 Data2Percentage %Name1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1,500,000&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 7,300,00021%Name2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 16,300,000&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 36,100,00045%&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 17,800,000 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 43,400,000 41%&nbsp;I need select: Name1 + Name2 with slicers and i need see 41% as value, not average, not sum, etc.&nbsp;Thanks you!

v-chuncz-msft · Answer

alv_ibar_123,
&nbsp;
You just need to add a measure.
Measure =
DIVIDE ( SUM ( Table1[Data1] ), SUM ( Table1[Data2] ) )

alv_ibar_123 · Answer

I have a measure in a card with the global result of the division, which works correctly with the slicers. But i can not use a measure in a combined graph, only was use columns calculated or normal.

In data i have more columns with month, year, area and others.

Forum Discussion

Combined graph doesnt calculated graph line

2 Replies

Related content

Tables combine

Combine CALCULATION DAX in Measure

Data Combining Problem

Combine Column

Combine two calculated tables

Slicers	Data1	Data2	Percentage %
Name1	1,500,000	7,300,000	21%
Name2	16,300,000	36,100,000	45%
	17,800,000	43,400,000	41%