Problem with count, different tables

[knche1234]

Hi! 

I need help with the following count scenario: 

Table 1 - Customers information ( Unique Customer ID)

 

Table 2 - Discounts done in many Months ( Many registers )

I need to count how many discounts I have in table 2 , adding this count in table 1 (New Column) 

This way I may know how many discounts have been applied to each customer!

I really apprecciate you help. 

[Vvelarde · Accepted solution]

@knche1234

hi, use this in a new calculated column

CountDiscount = COUNTROWS(RELATEDTABLE(Table2))

[knche1234]

Thank you! I'm new with power BI 😃