I need a way to ignore bar chart selection by keeping the original total via DAX query. (not through visual interactions.)
See below pic:
Where I have a ‘KPI total patients’ & a bar chart represents each day #. Simple.
Now, I need a way to keep this ‘Grand Total’ for the selected period with DAX Query: -
by ignoring any selection on bar chart. desired grant total = 1097. How do I achieve that ? Could someone please guide me?
I tried the function ALLSELECTED(). But is not working. ALLSELECTED() contains 1 day when a bar chart is clicked. – see measure: Total Patients (fixed).
here is the pbix file. PAS-New- AccessNumber attempt - added open orders compute.pbix (1.1 MB)