Measure for Percentage of Sale

[heygowtam]

Given Below Sample Data, 

1) Find "Down' and 'C-Down' sales together as  a Percentage in a Breed Column

2)  For the current Finacial Year and Previous Financial Year (July 22-July 21)

Date	Sales	Breed
12/07/2022	457	Merino
12/04/2021	56	Merino
7/06/2022	23235	Crossbed
10/05/2022	256	CrossBed
1/01/2022	257	Downs
1/06/2021	955	Crossbed
23/05/2022	65	C-Downs
15/08/2020	5	Downs
12/07/2021	665	C-Downs

[Jihwan_Kim]

Hi,

I am not sure if I understood your question correctly, but please check the below picture and the attached pbix file.

All measures are in the attached pbix file.

[heygowtam]

Can we make it automatic Date arrangement, rather than mentioning specific months @Jihwan_Kim 

[Jihwan_Kim]

Hi,

Thank you for your feedback.

Sorry that I do not understand the meaning, automatic date arrangement. 

Could you please provide how your desired visualizations look like together with expected result?