Measure similar to matrix table that can filter based on row subtotals

[DnBls]

Hi,

I have 2 related datasets that look like this:

Table1:

Table2:

The relationship here is via the 'index' column and it's one-to-many. I am trying to create a measure that would apply for example to a matrix table looking like this:

However, I want to filter outa whole column if the row total is for example is <=5. In this case Tuesday+Sunday would not appear in the table at all, while the Total Column would still contain the same counts as in the image. In an ideal scenario, Tuesday+Sunday would still appear in the table, but with all the values replaced by something like 'Not Applicable'.
I've searched around and not found a good response to this. Adding a Filter on the Visual would apply to each value of the matrix, rather than apply only based on row total.

Thanks

[DataInsights · Accepted solution]

@DnBls,

Try these measures:

Sum Value = SUM ( Table2[Value] )

Display Value = 
VAR vDayTotal =
    CALCULATE ( [Sum Value], ALLEXCEPT ( Table2, Table1[Day] ) )
VAR vResult =
    IF ( vDayTotal <= 5, "N/A", [Sum Value] )
RETURN
    vResult

[DnBls]

Thanks! Worked perfectly once adapted for my specific problem (added more filters to allexcept)!