Using New Measure, SUM all Defects with Filter for Fiscal Year

I created a sample file, only to realize that I can't upload, company doesn't permit Dropbox etc.

The sample file i created relationships are shown below.

RelationshipsRevenue table

dDate table

Relationships..

Models table to Sales table in linked via Model

dDate table is linked to Sales table via Date

Revenue table is linked to dDate table via Fiscal Year

Sales table

The Revenue table is shown detailing for each FY total units sold and total revenue

The Sales table contains the many observations.

The Sales table is also shown above, with 5 columns Date, Model Manufacturer, Qty & Amount

My ultimate require would be to show a clusterbar chart where for each Fiscal Year we would show the normalized % of total sales by Model / FY Revenue. As an expansion to this i would probably do the same for Manufacturer / FT Revenue.

For example let's say we have sales of Corrola's at $3,889,692 for FY20, with FY20 total revenue at $21,421907 results in 18.1%

I did add captions to the images so i hope they showup.

Thanks