I am using the below as my Dimension and Measure respectively.
Dimension:
if(aggr(RANK(Count(distinct{$<[Group]={'A'}>} ID)),[Product ])<=10,[Product ])
Measure:
=Num(Count(Distinct {<[Group]={'A'}, [Date]={"$(='>=' & Date(AddMonths(Max([Date]),-13)) & '<=' & Date(Max([Date]))))"}>} ID)
/
Count(Distinct {<[Group]=>} ID)
,'#,##0%')
This is to show Top 10 products and their respective % as a Measure. Now I have additional requirement where I need to show only those products in the chart that have Count(Distinct ID) >=50. I am not sure where and how to include this in Dimension/Measure. I tried using Product ={"=Count(Distinct ID)>=50 "} in Dimension/Measure but that's not helping.
