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
Anonymous
Not applicable

Not able t0 add measure value in to Custom column

Hi Experts,
I have a table as shown in the below:

Guruprasad_K_0-1600935872433.png


I'm trying to insert sum of 10+15+28 =53 in to Z5.

So i'm  trying to create new Custom Column like:
NEW= IF(Table[C2]="Z5",Tot_A,Table[Amt])


where, Tot_A= Calculate(SUM(Table[Amt]),Table[C1]="A")

 

PLEASE LET ME IF THIS IS POSSIBLE WITH DAX OR IS THERE A OTHER WAY?

 

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@Anonymous , Try a new column like

if([C2]="Z5",sumx(filter(Table, [C1]="A"),[Amt]),[Amt])

 

if this does not work

Can you share sample data and sample output in table format?

View solution in original post

2 REPLIES 2
amitchandak
Super User
Super User

@Anonymous , Try a new column like

if([C2]="Z5",sumx(filter(Table, [C1]="A"),[Amt]),[Amt])

 

if this does not work

Can you share sample data and sample output in table format?

Anonymous
Not applicable

Thank you @amitchandak 
It Worked!!

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.