Forum Discussion
Control Charting-ALLSELECTED
I was finally able to get this to work.
I used AllSELECTED as I described initially. What I had to do to make it work however was to duplicate my source table and filter it to be only the needed information. In this case the sample IDs.
Playing with KeepFilters a bit I can see why it is giving me that error. If I alter it a bit i.e. KeepFilters(Column="") i will not get the error. Unfortunately it also does not solve the initial issue.
I think I was a little off...try KEEPFILTERS() with whatever is on the X axis
I was finally able to get this to work.
I used AllSELECTED as I described initially. What I had to do to make it work however was to duplicate my source table and filter it to be only the needed information. In this case the sample IDs.
Could you please describe more of your solution.
Is dublicate source related to original table?
Do you use new table's ID on x-axle?
How do you filter new ID-table? Can you still use slicers?
I have similar case with control charts.
In my case there is quality data from different machines in the same table. On control chart I want to show only selected machine on selected timerange. I use slicer for that as I don't want to create 20 dublicate tables for each machine.
Evertyhing works fine until I add a measure that includes ALLSELECTED. See below.
Next I want to add AVG line, but this happens:
AVG-line is calculated correctly (includes only rows I have selected) but x-axle is still showing all the rows that should be filtered off.
DAX for AVG-line is: CALCULATE( [AVG_RH%], ALLSELECTED(Inspections[Id]))
Visual is filtered by using slicer, that actually filters 'machines' table. 'Machines' table is related to 'Inspections' table. Slicer filters linevalues on visual but x-axle values stay.
