Dynamic selection of Common records between multiple tables

[Pa1Kumar]

Hello Every one...

I am new to PowerBI and Happy to be part of Power BI Community Family...

I need to Count the Common Records Between the Selected Months and Display them in Visualizations like Barchart...

here are some points as per reqirement:

1.the chart should show the common no'of DC_MATERIAL_NAME count between Seleted months from the filter

2.the month filter should allow only 2 selections at a time.

3.in the above graph the maxmonth refer the maximum month selected from the filter and maxmonth-1 refer the other month selected

4.as and when the bar is clicked it should show the correspondind data records from the table also

5.We need to Pick the latest Status of record when ever it repeates in the month (We can assign the index for each month and can conside the max index)

I have Month Wise latest 4 months data set as below..

Ex :August_2022  to Nov_2022 here is the sampl table 

MARKET	MATERIAL_NAME	PROCESSING_STATUS
MME	E-DEG-71E2	FAILURE
MNAO	E-WZG-72A2_XML	SUCCESS
MC	E-DEG-72A2	FAILURE
MME	E-WWG-20E1EV_PDF	SUCCESS
MME	E-WWG-20E1EV_XML	SUCCESS
MNAO	1A87-1U-17F_MY2016_2018_XML	SUCCESS
MME	E-WES-03A1_XML	SUCCESS
MC	E-DES-36A1	FAILURE
MME	E-WES-36A2_XML	SUCCESS
MNAO	E-WES-74G1_XML	SUCCESS
MME	E-WZS-12A2_XML	FAILURE
MNAO	E-WEF-72A1_XML	SUCCESS
MME	E-WWF-59C1_PDF	SUCCESS

@PaulDBrown @amitchandak  @Fowmy  @Eyelyn9  @RicoZhou  @Vera_33  @Jihwan_Kim  @mahoneypat  @ImkeF  @DenisSlav   : Could any of you please help

[lbendlin]

You have not provided sufficient sample data. Please provide sample data that covers your issue or question completely.
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

[Pa1Kumar]

Thank you for you response and Help.Please find the below drive link for the excel files.

usp=sharinghttps://drive.google.com/drive/folders/1ZxxDJa8ExfB1yqjSZv-3dZnLgkupwCCN?usp=sharing 

My Expected out come is as below:

with a filter like latest 4 months

Those 6 bars shoud show:

Bar1 : Count of total material

Bar2 :Common material folder count between selected 2 months(by default 4months Common material folder count )

Bar3 :Common Success material folder count between selected 2 months(by default 4months Common success material folder count )

Bar4 :Common Failed material folder count between selected 2 months(by default 4months Common failed material folder count )

Bar5:Common material Folder Count Succeeded in Max-1 month( in this case Sep) and Failed in Max month (in this case Oct)(We have data from  July to Oct)

Bar6:Common material Folder Count Failed in Max-1 month( in this case Sep) and Success in Max month (in this case Oct)(We have data from  July to Oct).

your help would be greatly appreciated thank you in advance.

[lbendlin · Accepted solution]

See attached for a proposal to show bars 1 to 4.  I don't understand the logic for bars 5 and 6.