PBI count of unique and duplicates considering also some filters

Alexa1104 — Tue, 06 Feb 2024 10:37:49 GMT

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

Re: PBI count of unique and duplicates considering also some filters

amitchandak — Wed, 07 Feb 2024 08:04:19 GMT

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.

topic Re: PBI count of unique and duplicates considering also some filters in DAX Commands and Tips

PBI count of unique and duplicates considering also some filters

Re: PBI count of unique and duplicates considering also some filters