Forum Discussion

PaulSkuse's avatar
PaulSkuse
Regular Visitor
5 years ago

Matrix view and drilldown

Hey everyone!

 

I've got a Matrix problem! What I've got is a load of homes where I want to pull out the details on accidents and injuries. Everything looks great apart from...

 

The values are dates and a text field. These make sense when we drilldown a level to see each incident, but when everything is rolled up, I get the detail of just the first incident which is confusing and also means that whoever had the earliest accident is always shown until we drilldownn. Is there any way I can turn off the valuesuntil a drilldown is active?

 

Thanks!

Need Help

1 Reply

  • MFelix's avatar
    MFelix
    Icon for Super User rankSuper User
    5 years ago

    Hi PaulSkuse ,

     

    This depends on what you want to present but you need to create a measure similar to this one:

     

     

    Measure = IF(ISINSCOPE('Table'[LowestLevelColumn]); FIRSTNONBLANK('Table'[ColumnYouWantToPresent];1);BLANK())

     

    Then use this has you values on the matrix 

     

    Be aware that if you don't have any other values on your matrix you need to adjust the blanks to some other values otherwise you will not be abble to interact within the matrix since the rows are all presented blank when colappsed