Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Measure in Matrix not filtering

Hey everyone,

 

I have a matix visual with a 3-stepped hierarchy. I want to display only values for the lowest hierarchy, so no aggregated data for level 1 and 2, but only 3. This is reached using the following measure, which works:

 

_m_name =
VAR __SubTotal = ""
VAR __GrandTotal = ""
RETURN IF(
ISINSCOPE('table1'[name]) && ISINSCOPE('table1'[elementID])&& ISINSCOPE(table1[subelement]),
MIN('table1'[name]),
IF(ISINSCOPE('table1'[name]) && ISINSCOPE('table1'[elementID]),
__SubTotal,
__GrandTotal
)
)

 

As I have locations in my 'table1' I have also a table 'location' with all detailed location information.

When I now try to filter by the locations in my table 'location' the data is filtered, but a "" is displayed, so all of the items are still there, without displaying any data. I have a unique ID for every location which is linked between the two tables.

When I use the location in my table 'table1' everything works out fine and only the items are shown which are filtered.

 

Do I miss anything or whats my mistake here?

 

Thanks for your help!

Lukas

Need Help

1 Reply

  • amitchandak's avatar
    amitchandak
    Super User
    4 years ago

    Anonymous , As of now min will come from row context

    MIN('table1'[name])

     

    so you need what you want , across all

    calculate(MIN('table1'[name]), allselected(Table) )

     

    or

     

    calculate(MIN('table1'[name]), filter( allselected(Table), 'table1'[elementID] = max('table1'[elementID])

    && table1[subelement]   = max(table1[subelement]) ) )