PBI count of unique and duplicates considering also some filters

[Alexa1104]

Hello,

I have a difficult situation I am struggling with for some days now and I couldn't find any solution to it.

I will present it briefly : 

I have summarized in a new table the main columns involved . So I need to show in a visualization per each month:

-how many unique tests have been performed. 

-how many tests that have duplicates have been performed (but we count only 1 time each test)

- nr of their duplicates

Note : a test may be performed multople times per variant. 

A test which has been performed per more variants, is considered unique per each variant (duplicates if they exist are counted apart). 

I have tried many ideas, including the ALLEXCEPT function, but I can't manage to split this : tests which are performed more than 1 time : split into tests counted once + their duplicates. 

And all of this has to be applied after I select some filters : Started by CMD, Testname should not contain "stable_SW". (monthly)

Thank you in advance

[amitchandak]

@Alexa1104 , You Should create a measure

Non Distinct = Countrows(Table) - distinctcount(Table[Test ID])

If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.