Measure not crossfiltering other Visuals

[marcel97]

Hello all, 

I have this very basic issue which is driving me crazy nonetheless... 

Our PMO has a report covering the work package situation in our projects. There are 189 items in this project for example (I blacked out team and delivery names):

At the very bottom there is a table which can be crossfiltered to show the respective work packages/items by clicking on the Team Names or Delivery Names for example. The crossfiltering works well here as the displayed data comes directly form the tables and not from measures.

Now I want to implement a visual, that shows the number of items that have their analysis overdue. It is a very complex and customizable calculation, therefore I have to do it via a measure and cannot do it via a calculated column (the user can define custom deadlines to determine whether an item is overdue). Making the measure was easy by following a CALCULATE(DISTINCTCOUNT(), FILTER()) formula. I get the following result with 113 items being overdue:

So far so good. When I now click the 3 green (D - Information) items, the table crossfilters to 5 items however. Those are all items with that severity, regardless of whether they have their analysis overdue or not...

I tried implementing my measure as a filter on the visual that I used to crossfilter but it does not influence the result in any way. My desired output here would be that only the 3 overdue items are shown in the table when I crossfilter.

Any help is appreciated! Thanks in advance!

Kind regards

Marcel

[v-yueyunzh-msft]

HI , @marcel97 

According to your description, you want to cross-filter the table visual by your bar chart and you use a custom measure and you want to filter the table and just show which meet the overdue data.

If you need other visual filter the table visual by default just this visual need to filter the overdue data, here are the steps you can refer to :
(1)This is my test data:

(2)I create a measure like this to put in the bar chart:

Measure = CALCULATE( DISTINCTCOUNT('Table'[No]) , 'Table'[Date] > TODAY())

And i create this measure to judge if need to show in the table visual:

Over_analysis = IF( MAX('Table'[Date]) >TODAY() ,1,BLANK())

(3)We can  use the "Enter Data" to create a table just with one value:

Then we can put this measure on the  "Y-axis" in the bar chart:

Then we can create a measure like this:

Measure 2 = IF( ISFILTERED('Table2'[Flag]) , [Over_analysis] , 1)

And then we put this measure on the table visual's "Filter on this visual":

(4)Then we can get the result as follows.

When we select the "OverDate" bar chart :

When we select the other default bae chart :

If this method does not meet your needs, you can provide us with your special sample data and the desired output sample data in the form of tables, so that we can better help you solve the problem. (You can also upload you sample .pbix [without sensitive data] to the OneDrive and share with the OneDrive link to me ! )

Thank you for your time and sharing, and thank you for your support and understanding of PowerBI! 

Best Regards,

Aniya Zhang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly