topic Re: ALL from ALLSELECTED in Developer

ALL from ALLSELECTED

Analitika — Mon, 26 Jul 2021 10:42:06 GMT

How to filter ALL values from ALLSELECTED items?

I used filter in slicer and count with measure Allselected, it is ok, i got ALLselected Total

but now in matrix i need to select multiple items and show all matrix Total (previous Allselected Total)

https://file.io/UpPvB18ZWcrN

Re: ALL from ALLSELECTED

V-lianl-msft — Wed, 21 Jul 2021 06:02:12 GMT

Hi Analitika ,

Try REMOVEFILTERS .
REMOVEFILTERS is like ALL, but it can only be used as a filter argument in CALCULATE.

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Re: ALL from ALLSELECTED

V-lianl-msft — Tue, 27 Jul 2021 08:00:55 GMT

Hi Analitika ,

According to my test, the filtering behavior of visual interaction takes precedence over slicer, so it is suggested that you disable the interaction between visuals.

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Re: ALL from ALLSELECTED

Analitika — Tue, 27 Jul 2021 08:05:00 GMT

V-lianl-msftinteraction cant be disabled as measure used to display chart lines, so need disable it only by formula in measure