Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello All,
I've previosuly created control charts using a dataset with only the data needed. I am now trying to use the same measures to create the control charts where the data needed is only a subset.
I am using 4 measures, the two below and one to make the upper and lower limits.
With ALLSELECTED
Solved! Go to Solution.
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.
Hi @PBI_Rookie ,
Has your problem been solved? If it has been solved, please accept the correct reply as the standard answer to help the other members find it more quickly.Thank you very much for your kind cooperation!
Community Support Team _ Caitlyn Yan
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.
Hi! Try changing ALLSELECTED() to KEEPFILTERS(Identifier I want to sort by]).
Hi,
Ok I tried replacing the ALLSLECTED in both measures with KEEPFILTERS. I get an error that "Cannot convert value (identifier) of type TEXT to type True/False"
😮 Well that is certainly an unusual error message...
Can you provide some sample data to play with?
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
100 | |
88 | |
70 | |
61 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |