How to get a straight line in line and stacked column chart using value calculated from Measure??

[Anonymous]

I have taken emp_id on x-axis, column values as product_count (no. of products sold by emp_id) and for filtering I have taken (date slicer) and (stores).

Based on filter (date slicer and stores), I am getting avg_productivity dynamically per emp_id by using "New Measure".

Measure I am calculating using formula:

avg_productivity = SUM(table_name[product_count]) / DISTINCTCOUNT(table_name[emp_id])

I want to plot avg_productivity calculated above in a line(I am getting different values based on emp_id), but unable to do so, need quick help please.

Thank you in advance.

[v-piga-msft]

Hi @Anonymous,

Have you solved your problem?

If you have solved, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.

If you still need help, please share your desired output so that we could help further on it. 

Best Regards,

Cherry

[v-piga-msft]

Hi @Anonymous,

I have a little confused about your scenario.

Do you want to get the line like below?

If it is convenient, could you share the screenshot which could reproduce your scenario and share the output you desired so that I can understsand your requirement better.

Best  Regards,

Cherry