Mass Filter

[Oscar1991]

How to get a count of the inputs in a mass filter NOT found in the data base?

[v-echaithra]

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.

[v-echaithra]

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.

[v-echaithra · Accepted solution]

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.

[v-echaithra]

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.

[Oscar1991]

Doesn't work, and your pbix seems to work when I added more letter doesnt count them as wrong. 

[v-echaithra]

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.

[Oscar1991]

Not solved yet

[rajendraongole1]

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.