Forum Discussion
nirrobi
Helper V
Helper VSales table with 2 CustomerID columns
Hi, I have sales table with 2 customers column (actual + notify) and client table - table below. I need to show table with those 2 customers and the salesID + amount - table below. I hav...
As MEASURES
Notify_Name = CALCULATE ( FIRSTNONBLANK ( Customer[ClientName], 1 ), CROSSFILTER ( Sales[NotifyID], Customer[ClientID], BOTH ), USERELATIONSHIP ( Sales[NotifyID], Customer[ClientID] ) )
Zubair_Muhammad
Community Champion
Community Champion
nirrobiHelper V
Helper VMany thanks for your help!!!
Much appriciated.
I notice that you can't use the ClientName from the Customer table - make all the row duplicare - see attached pic.
please correct me if I wrong.
thanks again.
Nir