Aging Bucket - Measure on the fact table

[Heather]

for Item #1 consider a disconnected table to use for the visual - see this post for an example of how this can be done:

How to Change table visual via a slicer

@amruthdna2018, Here’s one way to do this: create a disconnected supporting table containing your desired slicer values, in this case Disconnected Employer Table = VALUES( Employee[Employer] ) create a measure like this: Invert Slicer = IF( MAX( Employees[Employer]) IN ALLSELECTED( ‘Disconnected Employer List’[Employer] ), 1, 0 ) In one copy of the visual, set your filter pane condition for that visual like this: [image] And for the other visual, set up the same way but with t…

for item #2 you can update your measure to use a trick that removes the totals, one popular choice is to include HASONEVALUE in the measure:

Remove total sum for a column

Hi, See example, DAX formula returns TRUE when the context for ColumnName has been filtered down to one distinct value only. no total = IF(HASONEVALUE(‘Table’[Month]);[Total Amount];BLANK()) Paul