Total %

Hi unnijoy ,

Thank you for reaching out to Microsoft Fabric Community.

Thank you Shahid12523 for the prompt response.

As Manager and Item are coming from different dimension tables, we need to ensure that the "Total Sales per Quarter" measure removes filters from both tables.

Try this adjusted measure:

Total Sales per Quarter =
VAR AnchorDate =
COALESCE (
SELECTEDVALUE ( 'Date'[QuarterStartDate] ),
MAX ( SalesFact[QuarterStartDate] )
)
VAR AxisQ = SELECTEDVALUE ( 'Quarter Axis'[QuarterStartDate] )
RETURN
CALCULATE (
[Sales Amount],
REMOVEFILTERS ( 'Date', 'Manager', 'Category' ),
KEEPFILTERS ( DATESINPERIOD ( 'Date'[Date], AnchorDate, -5, QUARTER ) ),
TREATAS ( { AxisQ }, 'Date'[QuarterStartDate] )
)
Then define % measure (You can use the same % measure given by Shahid12523 in his post.

Use this % measure in your matrix. It will show the correct per-item, per-manager percentage split within each quarter.
If this doesn't help, kindly share the PBIX file, so that it will be helpful for us to solve the issue.