Forum Discussion
Dynamic Line Chart with Total and many lines
Hi Experts I am trying to create and dynamic line chart based on status, current i have measure that is the sum the Staus A and B and I plot these to give me multiple line and then I sum the ...
Anonymous Please create two measure
Total = CALCULATE(SUM('Table (2)'[amount]),ALL('Table (2)'[status])) SelectedStatus = CALCULATE(SUM('Table (2)'[amount]),ALLSELECTED('Table (2)'[status]))First is for total and second is for selected status. let me know if have any question
Anonymous Please create two measure
Total = CALCULATE(SUM('Table (2)'[amount]),ALL('Table (2)'[status]))
SelectedStatus = CALCULATE(SUM('Table (2)'[amount]),ALLSELECTED('Table (2)'[status]))First is for total and second is for selected status. let me know if have any question
many thanks.. vimal much appericated.
hi vimal...
slight issue if you add a slicer to the pbix file, and you select only status A, the graph works fine, when you select both A and B i would expect to see two line and the total. But i am getting the sum of lines A and B and the total which is incorrect. see image