Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
ChPetru
Helper I
Helper I

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

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

1 ACCEPTED SOLUTION
tamerj1
Super User
Super User

Hi @ChPetru 

you can try

VAR Amount =

SUMX ( 

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

Transactions[Sales]
RETURN

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

)

View solution in original post

2 REPLIES 2
tamerj1
Super User
Super User

Hi @ChPetru 

you can try

VAR Amount =

SUMX ( 

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

Transactions[Sales]
RETURN

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

)

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

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.