Measure not affected by slicer

Hi! The measure is referencing the column directly with 'Table_name'[Fiscal Year] and 'Table_name'[Amount Due] instead of using measures, which means it's ignoring filter context from slicers. The ALLSELECTED is also removing the Invoice Type slicer context.

Try this for a fix: use CALCULATE to respect the current filter context, and use VALUES to capture the current Fiscal Year:

Invoice Rank by FY = VAR CurrentFY = SELECTEDVALUE('Table_name'[Fiscal Year]) RETURN RANKX( FILTER( ALLSELECTED('Table_name'), 'Table_name'[Fiscal Year] = CurrentFY ), CALCULATE(SUM('Table_name'[Amount Due])), , DESC, Dense )

The main issue was that raw column references inside RANKX don't respond to filter context the way measures wrapped in CALCULATE do — so the Invoice Type slicer was simply being ignored when evaluating the amount for each customer.