Relationship/Dax Function

Hi vinoothna9 ,

The reason that cause this issue is that you diable the date relationship between two tables so that the fiscal year slicer could not work and the visual will show both fiscal years value based on your initial measure.

You can modify your measure like this:

Revenue Amount = 
CALCULATE (
    SUM ( 'Revenue Table'[Revenue] ),
    FILTER (
        'Revenue Table',
        YEAR ( 'Revenue Table'[Date] )
            = SELECTEDVALUE ( 'Default Calendar'[Fiscal year] )
    ),
    USERELATIONSHIP ( 'Default Calendar'[Quarter], 'Revenue Table'[Quarter] )
)

In my sample use the table visual to show the result directly:

Attached the sample file in the below, hopes to help you.

Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.