Forum Discussion
Read values from filter (Mass Filter Slicer)
Thanks for the reply from MFelix , please allow me to provide another insight:
Hi, Martin2024
Thanks for reaching out to the Microsoft fabric community forum.Regarding the issue you raised, my solution is as follows:
1.Firstly, I created the following test data:
2.Secondly, I created the following calculated table to be used as a Mass Filter Slicer:
Table = VALUES('data table'[date])Please ensure that no relationships are established between the new table and the original table:
3.Next, I created the following measures:
Measure = IF(MAX('data table'[date]) IN VALUES('Table'[date]),0,1)4.And applied them to the visual objects:
5.Here's my final result, which I hope meets your requirements.
Please find the attached pbix relevant to the case.
Best Regards,
Leroy Lu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Martin2024 ,
I believe this is not possible since the DAX calculations are based on the context of the data and not on the text values that you write in your visualizations, in this case the Mass Slicer.
For this you would need for example to use Deneb to create a custom visual that would allow you to add the filter and have the calculation for each line of the written data. But not sure if this is possible also.
Hi MFelix ,
many thanks for your response. Unfortunately, I had this assumption too, but I was hoping that you could still get the information somehow, since it is displayed with the filter symbol on the table.
Maybe someone else has another idea on how to implement my plan?
I wish everyone a merry Christmas.
Best regards
Martin
Thanks for the reply from MFelix , please allow me to provide another insight:
Hi, Martin2024
Thanks for reaching out to the Microsoft fabric community forum.Regarding the issue you raised, my solution is as follows:
1.Firstly, I created the following test data:
2.Secondly, I created the following calculated table to be used as a Mass Filter Slicer:
Table = VALUES('data table'[date])Please ensure that no relationships are established between the new table and the original table:
3.Next, I created the following measures:
Measure = IF(MAX('data table'[date]) IN VALUES('Table'[date]),0,1)4.And applied them to the visual objects:
5.Here's my final result, which I hope meets your requirements.
Please find the attached pbix relevant to the case.
Best Regards,
Leroy Lu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hello in my case this is not a solution, my issue is if the data base only has 12345 & 23456, I need the mass filter to check the input and if the user inputs is 333, to return that 333 is not found on database, and counst the errors, or the no hits in database
Hi Oscar1991 ,
Has I refered previously to my konwledge you cannot get the values written in a filter, slicer, ... into a card since you can only access the data in the columns, altough the values are taken into the visual itself and you can see it in the Filter Icon in the visual I believe that this is based on the engine of Power BI and Vertipaq and you cannot access that data directly.
