Forum Discussion
Filter a certain value without affecting the others
Hi, May I know if it is possible to filter a graph wherein all values will be fixed except for one. Say, the following graph. I have a filter for Brands within the same hierarchy as Manufact...
v-xicai
Community Support
Community SupportHi Anonymous ,
You may create measure using ALLSELECTED and ALL function, then put the new measure onto Values box of Line chart.
Measure1=IF(Table1[Manufacturer]="ValC", CALCULATE(MAX(Table1[Market Share]),FILTER(ALLSELECTED(Table1), Table1[Manufacturer]=MAX(Table1[Manufacturer]))), CALCULATE(MAX(Table1[Market Share]),FILTER(ALL(Table1), Table1[Manufacturer]=MAX(Table1[Manufacturer]))))
If I misunderstood it, could you please share your sample data and desired output screenshots for further analysis? You can also upload sample pbix to OneDrive and post the link here. Do mask sensitive data before uploading.
Best Regards,
Amy
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Unfortunately, I get the following error and the Manufacturer data can't be used as well.