The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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)
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.
@V-lianl-msftinteraction cant be disabled as measure used to display chart lines, so need disable it only by formula in measure
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.