Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 Account | Vendor Account | Customer dimension description | Vendor dimension description | Customer Main Account Meas | Customer Amount | Vendor Main Account Meas | Vendor Amount | Customer Total Amount | Vendor Total Amount | Controle |
F001_ICC0003 | F008_ICV0290 | HANA GROUP LEVALLOIS | SUSHI GOURMET | 41110009 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_ICC0005 | F010_ICV0290 | HANA GROUP VELIZY | SUSHI GOURMET | 41110009 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_ICC0006 | F009_ICV0290 | SUSHI GOURMET ORVAULT | SUSHI GOURMET | 41110009 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_ICC0008 | F012_ICV0290 | SUSHI GOURMET NICE | SUSHI GOURMET | 41110009 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_ICC0010 | F015_ICV0290 | SUSHI GOURMET MONTPELLIER | SUSHI GOURMET | 41110009 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_ICC0013 | F016_ICV0290 | SUSHI GOURMET CALUIRE | SUSHI GOURMET | 41110009 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_ICC0014 | F018_ICV0290 | SUSHI GOURMET FACHES | SUSHI GOURMET | 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 | €-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
| -€ 463,145.19 | -€ 156,447.28 | -€ 619,592.4 7 |
DAX:
Could you please advise.
Thanks
Vinoth SUSAINATHAN
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
99 | |
73 | |
72 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |