Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Solved! Go to Solution.
@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
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
many thanks.. vimal much appericated.
User | Count |
---|---|
128 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |