Forum Discussion
FILTERING PROBLEM
Hi Preboat ,
Thanks for sharing the PBIX.I checked the setup and noticed that the ShowRow logic you had earlier was being used separately, which meant the visual still showed unwanted rows unless filtered explicitly.
I’ve modified the calculation items to embed the ShowRow flag logic directly inside them, so that they return BLANK() when the rate is less than or equal to 0.5.
TDA = IF( [ShowRow_Flag] = 1, SELECTEDMEASURE(), BLANK() )TBA = IF( [ShowRow_Flag] = 1, IF(ISINSCOPE(Append1[Category]), BLANK(), SUM(Append1[SUMbill])), BLANK() )Rate = IF( [ShowRow_Flag] = 1, IF(NOT ISINSCOPE(Append1[Category]), DIVIDE(SELECTEDMEASURE(), SUM(Append1[SUMbill]))), BLANK() )This way, the matrix automatically hides those rows without needing an additional measure or filter pane configuration.
Result:
Attached the pbix file for reference.
Hope this helps. Please reach out for further assistance.
Thank you.
Hi v-veshwara-msft
Thanks for your suggestion. This is how my table looks like currently 👇
| Name | 24 | 7 | 30 | 4 | 15 | Grandtotal | Total Bill | Rate |
| c n ii | 30 | 2 | 3 | 4 | 4 | 43 | 754 | 5.70% |
| wewdd | 4 | 1 | 40 | 1 | 1 | 47 | 75 | 62.67% |
| wee | 4 | 10 | 30 | 5 | 40 | 89 | 170 | 52.35% |
| nvnn | 3 | 2 | 43 | 3 | 32 | 83 | 350 | 23.71% |
| Grandtotal | 41 | 15 | 116 | 13 | 77 | 262 | 1349 | 144% |
And my code as indicated is giving me blanks at just the total column without removing the individual rows also where the rate is >0.5. I tried your suggestion but it is still not removing those rows. Below is what my result is looking like currently.
Rows "c n ii" and "nvnn" where the rate is less than 0.5 has the grandtotal blanks but the detail row remains but i want that whole row taken out.
| Name | 24 | 7 | 30 | 4 | 15 | Grandtotal | Total Billed | Rate |
| c n ii | 30 | 2 | 3 | 4 | 4 | 754 | 5.70% | |
| wewdd | 4 | 1 | 40 | 1 | 1 | 47 | 75 | 62.67% |
| wee | 4 | 10 | 30 | 5 | 40 | 89 | 170 | 52.35% |
| nvnn | 3 | 2 | 43 | 3 | 32 | 350 | 23.71% | |
| Grandtotal | 41 | 15 | 116 | 13 | 77 | 262 | 1349 | 144% |
Thanks
Hi Preboat ,
Thanks for the update.
Since the issue still persists even after trying the suggested approach, could you please share the .pbix file so we can assist more accurately and effectively.
You can upload the file to your OneDrive or Google Drive and share the link here with the necessary access permissions.
Please follow this guide to share sample data or .pbix: How to provide sample data in the Power BI Forum - Microsoft Fabric Community
Thank you.
Hi v-veshwara-msft
I have used a sample data since the original is connected to the server. Essentially, what i want to achieve is to filter the matrix visual to just show rows where the rate is greater than 0.5.
FILTERING PROBLEM2.pbix
ThanksHi Preboat ,
Thanks for sharing the PBIX.I checked the setup and noticed that the ShowRow logic you had earlier was being used separately, which meant the visual still showed unwanted rows unless filtered explicitly.
I’ve modified the calculation items to embed the ShowRow flag logic directly inside them, so that they return BLANK() when the rate is less than or equal to 0.5.
TDA = IF( [ShowRow_Flag] = 1, SELECTEDMEASURE(), BLANK() )TBA = IF( [ShowRow_Flag] = 1, IF(ISINSCOPE(Append1[Category]), BLANK(), SUM(Append1[SUMbill])), BLANK() )Rate = IF( [ShowRow_Flag] = 1, IF(NOT ISINSCOPE(Append1[Category]), DIVIDE(SELECTEDMEASURE(), SUM(Append1[SUMbill]))), BLANK() )This way, the matrix automatically hides those rows without needing an additional measure or filter pane configuration.
Result:
Attached the pbix file for reference.
Hope this helps. Please reach out for further assistance.
Thank you.
Hi Preboat ,
Just wanted to check if the response provided was helpful. If further assistance is needed, please reach out.
Thank you.