Forum Discussion

Steve_M's avatar
Steve_M
Frequent Visitor
1 year ago
Solved

AS AT slicers

Hi, I am trying to create an “AS AT” AR Aging report. I have a Live connection but I don’t have access to make changes to the underlying data model, so I am trying to do everything in DAX. If I ...
Need Help
  • danextian's avatar
    danextian
    1 year ago

    Hi Steve_M 

    As mentioned in  my previous reply, filters coming from a related table will affect what records are visible.  So if you select 28/11, you will see only the 28/11 rows. Functions such as ALL, ALLSELECTED, REMOVEFILTERS etc affect the results of a measure but cannot unhide the non-selected rows.  Change your slicer to before if you want to also show rows with dates prior to the currently selected.

     

danextian's avatar
danextian
Icon for Super User rankSuper User
1 year ago

Hi Steve_M 

As mentioned in  my previous reply, filters coming from a related table will affect what records are visible.  So if you select 28/11, you will see only the 28/11 rows. Functions such as ALL, ALLSELECTED, REMOVEFILTERS etc affect the results of a measure but cannot unhide the non-selected rows.  Change your slicer to before if you want to also show rows with dates prior to the currently selected.

 

Steve_M's avatar
Steve_M
Frequent Visitor
1 year ago

Thank you, I think this will work with Samarth's code.