Forum Discussion
Mass Filter
Hi Oscar1991 ,
Thank you for the update.
Can you please share a sample data and also expected output here, we will work on it and provide you the solution you are looking for.
Need help in uploading sample file? How to provide sample data in the Power BI Forum - Microsoft Fabric Community
Best Regards,
Chaithra E.
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.
Doesn't work, and your pbix seems to work when I added more letter doesnt count them as wrong.