multiple line graph with overall total based on slicer selection criteria

[Anonymous]

Hi Experts

I have cannot see the wood for the trees, here not sure if this can be done, see pbix file. 
1. I have created a total measure which gives me the overall total value for the status points (correct) 
2. i have a measure called selcetedvlaues which should allow me to plot the selected status against the total value which works fine for a single data point. 
3. i have two measure status A and B which give me the correct plots for the single selected data point against grand total line, but i do not want to create 50 measures for all my products. 
can this not be done dynamically based on selelcted from slicer.

https://www.dropbox.com/s/86i4f108hb4v5w3/line_and_bar.pbix?dl=0

[v-xicai · Accepted solution]

Hi @Anonymous ,

You can create measure using ALLSELECTED function like DAX below.

 Status_selected = CALCULATE(SUM('Table (2)'[amount]), ALLSELECTED('Table (2)'[status]))

Best Regards,

Amy

Community Support Team _ Amy

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

hi AMy 

taht dax measure will not give me a plot for a and b and the total. i need to be able to show three lines on plot.