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

[rahsingh]

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 

[v-eachen-msft]

Hi @rahsingh ,

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

[amitchandak]

How these two tables is related.

If there have direct join

You can add the filter in you formula

filter(Table,[Dalyed Invoice] >0)

[rahsingh]

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 

[amitchandak]

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

[rahsingh]

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