Mass Filter

Hi Oscar1991 - 

Please find the below reference links:

(1) Solved: Mass Filter - Microsoft Fabric Community

In Power BI , we can use ALL(), Allexcept(), removefilter() functions. please check the link below.

Filter functions (DAX) - DAX | Microsoft Learn

EXCEPT function (DAX) - DAX | Microsoft Learn

hope this helps.

Hi Oscar1991 

Thank you rajendraongole1  for your inputs.

May I ask if you have gotten this issue resolved by the solution provided by our super user ?

If it is solved, please mark the helpful reply or share your solution and accept it as solution, it will be helpful for other members of the community who have similar problems as yours to solve it faster.

Regards,
Chaithra.

Hi Oscar1991 ,

To count the inputs selected in a slicer or mass filter that are not found in your data table in Power BI, follow the below steps using a disconnected table and a DAX measure.

Create a Disconnected Input Table, and that should be used as the source for your mass filter.

Add FilterInput[Item] as a mass filter.

Add the measure missing count to a card or visual, inorder to get the count.

Missing Count =
VAR SelectedValues = VALUES(FilterInput[Item])
VAR ExistingValues = VALUES('FactTable'[Item])
RETURN
COUNTROWS(
EXCEPT(SelectedValues, ExistingValues))

Please refer to the PBIX file below.
I hope this helps.

Best Regards,
Chaithra E.

Hi Oscar1991 ,

We’d like to confirm whether your issue has been successfully resolved. If you still have any questions or need further assistance, please don’t hesitate to reach out. Please provide a sample data to provide solution on your requirement. We’re more than happy to continue helping you.

Best Regards,
Chaithra E.

Hi Oscar1991 ,

We’d like to confirm whether your issue has been successfully resolved. If you still have any questions or require further assistance, please don’t hesitate to contact us. To help us provide a more accurate solution, kindly share a sample of your data. We’re more than happy to continue supporting you.

Best regards,
Chaithra E.