Slicers that adjust based on each other

[nzcatala]

Here's a simplified version of what I'd like to see in my report.

ID_Table

ID   Outages

1    3

2    2

The "Outages" Column would be calculated with something like:

=CALCULATE(COUNT(Outage_Table[ID]),ALLEXCEPT(ID_Table,ID_Table[ID]))

Outage_Table

ID   Date

1    8/9/2018

1    8/10/2018

1    8/11/2018

2    8/9/2018

2   8/10/2019

What I would love to see is having two filter, one that allows me to adjust the number of outages, so that I can see all customers with more than 4 outages for example, but I would also like to be able to say "How many customers have had 4 or more outages in the last 3 months"

Because I'm using a calculated column, it doesn't adjust based on the filter.  Is there a good workaround?

[Joorge_C · Accepted solution]

I think the only way to do this is have Columns and not meassures in a hierarchy table sort of say.

If you do all this in Excel and upload your final table for a full year of data, then you could have the different values accross slicers and all would be in sync

[nzcatala]

I figured as much.  Thanks for the help!

[v-chuncz-msft]

@nzcatala,

You may also take a look at https://community.powerbi.com/t5/Desktop/Create-a-bar-graph-with-measures-as-axis/td-p/455900.