How to tag a dimension with an attribute based on other attributes

[ChPetru]

Hello,

I have sales data in two tables: Fact Table + Accounts Table.

I am trying to create a calculated column in the accounts table, that is equal to "Big Account" if the customer has bought a certain product on the Fact Table, or "Small Account" if they did not buy that product.

I'm thinkinh I should do a variable that returns all the 'Big Accounts' and the calculated column should have a condition (IF?) that says: if Account in the list returned by variable, then = Big Account.

Can someone help me with sytnax?

The field Names:

Account[Account Name]

Account[Big Account?] = ???

Transactions[Account Name]
Transactions[Product Name]

thank you

[tamerj1 · Accepted solution]

Hi @ChPetru 

you can try

VAR Amount =

SUMX ( 

FILTER(RELATEDTABLE(Transactions), Transactions[Product Name] = "ProductName"),

Transactions[Sales]
RETURN

IF ( Amont > 0, "Big", "Small )

)

[ChPetru]

Thank you, it works with one little tweak: instead of sumx I used countrows.