Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
rahsingh
Frequent Visitor

How to filter a table based on a measure which counts number of Delayed Invoices

Hi Everyone, 

 

I have a measure which counts the number of Delayed Invoices ,  i  would like to filter the Table which contains all the invoice details when users click on the Number of Delayed Invoices Measure to just the delayed Invoices  . Currently i am unable to do so , any suggestion would be great. 

 

Thanks 

5 REPLIES 5
v-eachen-msft
Community Support
Community Support

Hi @rahsingh ,

 

You could try to add this measure into filter pane of the table visual. Then set the rule as "measure >0".

 

Community Support Team _ Eads
If this post helps, then please consider Accept it as the solution to help the other members find it.
amitchandak
Super User
Super User

How these two tables is related.

If there have direct join

You can add the filter in you formula

filter(Table,[Dalyed Invoice] >0)

Thank you for replying @amitchandak  I do have a Inner Join on my tables  but this is a measure not a Calculated column , Here is my Measure DAX hope this helps. 

 

DelayedInvoices = if(isblank(CALCULATE(count(Invoice[Id]),filter(Invoice,Invoice[Timeliness]="Delayed"))),0,CALCULATE(count(Invoice[Id]),filter(Invoice,Invoice[Timeliness]="Delayed")))

This gives me a result of 16 Invoices and now when i click on 16  i want it to filter the Table grid to those 16 Invoices which are delayed. 

 

Just to be clear Table grid is one visual and Count Measure is another visual. 

 

Hope this helps 

 

I doubt click on card or number will add filter. But you can manage that by drill through or Bookmarks have table with that filter and drill or show that.

https://docs.microsoft.com/en-us/power-bi/desktop-drillthrough

https://radacad.com/bookmarks-and-buttons-making-power-bi-charts-even-more-interactive

@amitchandak  The links is about how to hide and show a visuals but it does not talk about filtering to the grid.

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.