Distinct Count of a column based on another column with data filter capability

Hi vvibhakar 

Calculated column can not be dynamic impacted by slicer, but measure can.

For reference: What is the difference between Power BI calculated columns and measures?

Here I suggest you to create a table with whole number you want to select in slicer ,then create a count measure and filter your user result by another filter measure based on this count measure.

1. Create a table for slicer.

Count Slicer = GENERATESERIES(1,5) 

2.Create measures.

DISTINCTCOUNT = CALCULATE(DISTINCTCOUNT('Table'[Product]),ALLEXCEPT('Table','Table'[User],'Table'[Category]))

Filter = IF(ISFILTERED('Table'[Category]),1,IF([DISTINCTCOUNT] in VALUES('Count Slicer'[Value]),1,0))

Create a table visual by User column and [DISTINCTCOUNT] measure, then add [Filter] measure into filter field in this visual and set it to show items when value =1. Result is as below.

By default :

Select 3 in Value:

Select A1 in Category:

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.