cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Helper II
Helper II

Unable to summarize the matrix table column same values in the cell (DAX)

Hi,

I have a final matrix table combining two tables. Is it possible to summarize the matrix table column(Vendor Main Account Meas) same values in a cell.

 

Customer AccountVendor AccountCustomer dimension descriptionVendor dimension descriptionCustomer Main Account MeasCustomer AmountVendor Main Account MeasVendor AmountCustomer Total AmountVendor Total AmountControle
F001_ICC0003F008_ICV0290HANA GROUP LEVALLOISSUSHI GOURMET41110009
45100000
45100000
€213866,45
€287854,05
€1816,56
40110019
40110019
40110019
40110019
40110019
40110019
€109594,9
€-5760
€-5760
€-30500,78
€-230749,34
€-50691,23
€ 503,537.06-€ 213,866.45€ 289,670.61
F001_ICC0005F010_ICV0290HANA GROUP VELIZYSUSHI GOURMET41110009
45100000
€411225,49
€611280,78
40110019
40110019
40110019
40110019
40110019
40110019
€229252,08
€-8880
€-8880
€-50876,53
€-85458,59
€-482684,57
€ 1,022,506.27-€ 407,527.61€ 614,978.66
F001_ICC0006F009_ICV0290SUSHI GOURMET ORVAULTSUSHI GOURMET41110009
41110009
41110009
41110009
41110009
41110009
45100000
45100000
45100000
45100000
45100000
45100000
45100000
45100000
45100000
45100000
45100000
45100000
45100000
45100000
45100000
45100000
45100000
45100000
45100000
45100000
45100000
45100000
45100000
45100000
45100000
45100000
45100000
45100000
45100000
45100000
45100000
45100000
45100000
45100000
45100000
45100000
45100000
45100000
45100000
45100000
45100000
45100000
45100000
45100000
45100000
45100000
45100000
45100000
45100000
45100000
45100000
45100000
45100000
45100000
45100000
45100000
45100000
45100000
45100000
€-358733,28
€-26095,38
€-25899,53
€-606
€-27662,74
€-23308,68
€-31559,43
€-26743,28
€-625,28
€-27836,4
€-28794,39
€-1076,77
€-66030,95
€54399,85
€139026,53
€1560
€41104,72
€1560
€11013,31
€1,68
€1558,18
€5931,07
€0,21
€130
€3820
€16383,54
€1,26
€3343,31
€50,38
€51,37
€10326,74
€1,68
€1753,11
€1558,18
€10195,02
€0,21
€130
€3587
€10115,39
€1,05
€0,21
€0,21
€9514,64
€46,53
€1,47
€1815,97
€807,7
€130
€5914
€0,25
€10132,91
€1,26
€3321,91
€43,2
€10420,35
€45,07
€1,68
€1558,18
€18575,79
€1,26
€130
€3880
€5963,2
€0,42
€672
40110019
40110019
40110019
40110019
40110019
40110019
45100000
45100000
45100000
45100000
€66030,95
€817,76
€28117,61
€31911,65
€678,56
€-1560
€-1560
€-41104,72
€-54399,85
€-139026,53
-€ 254,390.11-€ 110,094.57-€ 364,484.68
F001_ICC0008F012_ICV0290SUSHI GOURMET NICESUSHI GOURMET41110009
45100000
45100000
€96764,63
€2,82
€228314,37
40110019
40110019
40110019
40110019
40110019
40110019
€49877,24
€-2160
€-2160
€-13564,64
€-105015,3
€-23741,93
€ 325,081.82-€ 96,764.63€ 228,317.19
F001_ICC0010F015_ICV0290SUSHI GOURMET MONTPELLIERSUSHI GOURMET41110009
45100000
45100000
€85756,09
€153344,28
€1535,17
40110019
40110019
40110019
40110019
40110019
40110019
€41073,88
€-1680
€-1680
€-14255,7
€-86480,03
€-22734,24
€ 240,635.54-€ 85,756.09€ 154,879.45
F001_ICC0013F016_ICV0290SUSHI GOURMET CALUIRESUSHI GOURMET41110009
45100000
€193074,05
€421263,7
40110019
40110019
40110019
40110019
40110019
40110019
€98275,31
€-4080
€-4080
€-28099,9
€-206916,23
€-48173,23
€ 614,337.75-€ 193,074.05€ 421,263.70
F001_ICC0014F018_ICV0290SUSHI GOURMET FACHESSUSHI GOURMET41110009
45100000
45100000
45100000
45100000
45100000
45100000
45100000
45100000
45100000
45100000
45100000
45100000
45100000
45100000
45100000
45100000
45100000
45100000
45100000
45100000
45100000
45100000
45100000
45100000
45100000
45100000
45100000
45100000
45100000
45100000
45100000
45100000
45100000
45100000
45100000
45100000
45100000
45100000
45100000
45100000
45100000
45100000
45100000
45100000
45100000
45100000
45100000
45100000
45100000
45100000
45100000
45100000
45100000
45100000
45100000
45100000
€-492271,75
€-31346,4
€-32850,58
€-32638,24
€-28842,74
€-28996,13
€-30332,54
€-32380,52
€-34273,03
€-477,85
€-36747,92
€153567,28
€11425,73
€1,26
€68,4
€738,34
€0,21
€738,34
€0,21
€5358
€19875,56
€1,47
€1161,52
€41
€1377,66
€43,39
€47,12
€10702,98
€1,26
€1520,59
€13247,05
€0,42
€11548,5
€0,84
€11336,51
€50,2
€1,26
€1154,14
€5614
€9570,78
€1,05
€11360,76
€0,42
€3977,17
€11059,52
€44,51
€1,26
€5283
€935,3
€30
€77
€0,21
€23604,15
€1,05
€1087,84
€77
€1278,25
40110019
40110019
40110019
40110019
40110019
40110019
40110019

€74551,04
€-2880
€-2880
€-24080,62
€-2880
€-156965,38
€-41312,32

 

 

-€ 463,145.19-€ 156,447.28

-€ 619,592.4

7

 

DAX:

Customer Main Account Meas = SUMMARIZE('Customer Ledger Transactions',
"Customer Main Account", CONCATENATEX('Customer Ledger Transactions','Customer Ledger Transactions'[MainAccount]
,
UNICHAR(10),'Customer Ledger Transactions'[MainAccount],ASC
)
)

Could you please advise.

 

Thanks

Vinoth SUSAINATHAN

 

4 REPLIES 4
Community Support
Community Support

Hi,

 

Please try to create a measure by using 'SUM' to calculate the sum of [Customer Amount].

 

Best Regards,

Giotto Zhi

Thank you for your reply.

Actually these multiple  customer amounts are in a single cell. Like that we have multiple customer amounts, Customer Main accounts,vendor Mainaccounts and vendor amounts. How can we summarize this by Customer main accounts and vendor main accounts.

 

Please advise.

 

Thanks

Vinoth

Hi,

 

Please refer to this:

https://www.excelguru.ca/blog/2015/10/16/split-by-line-breaks/ 

Hope this helps.

 

Best Regards,

Giotto Zhi

Hi,

Thank you for your reply.

Could you please advise in the DAX. We have built this data from measures and we would like to fix this in dax. Is it possible to do that.

 

 

Thanks

Vinoth SUSAINATHAN

Helpful resources

Announcements
secondImage

Congratulations!

We are excited to announce the Power BI Super Users!

Wave Release 2

Check out the updates in Power BI.

Overview of Power BI 2020 release wave 2!

Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors