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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

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
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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

Top Solution Authors