Forum Discussion

PaulBoden's avatar
PaulBoden
Helper I
3 years ago

Filter on Matrix table

Hi all,

 

I'm having an issue where a filter doesn't seem applying correctly in my matrix table. I'm a bit stumped as all of the underlying logic seems to be functioning correctly to populate the table with the proper values but the basic [Measure X] is [Value Y]  filter doesn't seem to be working as expected.

 

I've included a screenshot below by way of example. You'll notice that in the highlighted row, every instance of the #_AvailThresholdFilter field contains '0', yet the row is still being returned when this visual is filter to only include '1'. What I anticipated was that only rows, with at least one field containing a '1' would be returned. 

 

 

 

Any suggestions? Thanks

Need Help

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi PaulBoden ,

    If I understand correctly, the visual-level filter with the condition ([#_AvailThresholdFilter] is 1) seems not working in your report. The visual should only display the data which [#_AvailThresholdFilter] is 1, but it return all data with both 0 and 1...

    In order to make troubleshooting and give you a suitable solution, could you please provide some raw data in your table (exclude sensitive data) with Text format and the formula of measure [#_AvailThresholdFilter]? It would be helpful to find out the solution. You can refer the following links to share the required info:

    How to provide sample data in the Power BI Forum

    How to Get Your Question Answered Quickly

    And It is better if you can share a simplified pbix file. You can refer the following link to upload the file to the community. Thank you.

    How to upload PBI in Community

    Best Regards