Customer occurence with filter

Hi,

I think bar chart is ideal in this scenarios because it's easy to compare different categories (in this case, the types of discount coupons) by visually representing the data with bars of varying lengths. Secondly, the visual separation of bars helps in quickly identifying which coupon type had more returning customers. Lastly, the differences in bar lengths immediately highlight the variations in the number of customers for each coupon type.

Hi Kaviraj11 ,thanks for the quick reply, I'll add more.

Hi Jidnyasa2904 ,

The Table data is shown below:

Use the following DAX expression to create  measures

Total_returning_customers = 
VAR _table = SUMMARIZE('Table',[Customer ID ],"Returning Customers",COUNTROWS('Table'))
RETURN COUNTROWS(FILTER(_table,[Returning Customers] >= 2 ))

which_coupon = 
VAR _coupon = SELECTEDVALUE('Table'[Coupon])
RETURN COUNTROWS(FILTER('Table','Table'[Coupon] <> "20%off" && 'Table'[Coupon] = _coupon))

Final output

Best Regards,
Wenbin Zhou