Use Measure to return multiple values for a line graph

Question

I have this measure below which returns a value based on slicers. It works well and currently returns 'All&nbsp;Projections'[FORECAST] to be on a line graph. Is there any way I can change this measure so that it can return TWO values to make two lines? In addition to [FORCAST] I also have [COUNTS] as a separate column in the same table.&nbsp;Thanks!&nbsp;counts_forecast&nbsp;=&nbsp; &nbsp; &nbsp; VAR&nbsp;sitecount&nbsp;=&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; CALCULATE&nbsp;(&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;DISTINCTCOUNT&nbsp;(&nbsp;'All&nbsp;Projections&nbsp;Bridge'[site&nbsp;number]&nbsp;),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;ALLSELECTED&nbsp;(&nbsp;'All&nbsp;Projections&nbsp;Bridge'&nbsp;),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;ALLSELECTED&nbsp;(&nbsp;'All&nbsp;Projections&nbsp;Legend'&nbsp;)&nbsp;&nbsp;&nbsp;&nbsp;)VAR&nbsp;proccount&nbsp;=&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;CALCULATE&nbsp;(&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;DISTINCTCOUNT&nbsp;(&nbsp;'All&nbsp;Projections&nbsp;Bridge'[procedure&nbsp;number]&nbsp;),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;ALLSELECTED&nbsp;(&nbsp;'All&nbsp;Projections&nbsp;Bridge'&nbsp;),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;ALLSELECTED&nbsp;(&nbsp;'All&nbsp;Projections&nbsp;Legend'&nbsp;)&nbsp;&nbsp;&nbsp;&nbsp;)VAR&nbsp;levelnum&nbsp;=&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;SWITCH&nbsp;(&nbsp;TRUE&nbsp;(),&nbsp;sitecount&nbsp;=&nbsp;1,&nbsp;3,&nbsp;proccount&nbsp;=&nbsp;1,&nbsp;2,&nbsp;1&nbsp;)RETURN&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;CALCULATE&nbsp;(&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;SUM&nbsp;(&nbsp;'All&nbsp;Projections'[FORECAST]&nbsp;),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;'All&nbsp;Projections&nbsp;Legend'[Level]&nbsp;=&nbsp;levelnum&nbsp;&nbsp;&nbsp;&nbsp;)

syk · Answer

A single measure won't be able to give you 2 different lines. But, you can create a new measure to look specifically at counts and add that to your chart!

anonymous · Answer

I would do this, however; when you use two measures in the "values" section of the line graph, you can no longer have anything in the legend. The purpose of this measure is to use a dynamic legend/graph so that is not an option for me unfortunately.

anonymous · Answer

Hi&nbsp;Anonymous&nbsp;,
Please refer to the following topics.
https://community.powerbi.com/t5/Desktop/How-to-create-two-lines-in-a-line-chart/td-p/135098
https://community.powerbi.com/t5/Desktop/Display-2-lines-for-different-years-in-a-line-chart/td-p/1787296
&nbsp;
If I have misunderstood your meaning, please provide your pbix file without privacy information and desired output.
&nbsp;
Best Regards
Community Support Team _ Polly
&nbsp;
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Forum Discussion

Use Measure to return multiple values for a line graph

3 Replies

Related content

Measure returning incorrect value

Measure to return multiple values

Measure and return multiple columns

Measure is returning BLANK

DAX Measure Returning Incorrect Results