Forum Discussion
multiple line graph with overall total based on slicer selection criteria
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
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.
2 Replies
v-xicaiCommunity Support
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.