Hi all, I would like to implement two slicers on a table similar to the one below. One for date and the other one for duplicates. For example, if the Duplicate/Original slicer says "Original" and Date Slicer says "01-01-2022" to "07-01-2022" the visual should show "3" and if the Duplicate/Original says "Duplicate" in the same date range, the visual should show 4. Thanks.

Hi, ashu710 Try this: result = VAR _originalValues = DISTINCTCOUNT( yourTable[valuesColumn] ) VAR _duplicateValues = COUNT( yourTable[valuesColumn] ) - _originalValues VAR _if = SWITCH( TRUE(), SELECTEDVALUE( 'theTable'[Slicer] ) = "Original", _originalValues, SELECTEDVALUE( 'theTable'[Slicer] ) = "Duplicate", _duplicateValues ) RETURN _if Best Regards,Community Support Team _ Zeon Zheng If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Duplicates using Date and Duplicate/Original Slicer

Forum Discussion

Related content

Duplicated table displays a different row count from the original table - why?

DAX Help: Find Duplicate Values and Mark duplicated values as Zero and the original as One

Duplicate ranking

Duplicated column affects original when adding filters

Duplicate Slicer Question