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.
Hello Everyone,
I'm trying to extract the unique values onto a calculated table but seems doestn work my DAX? I was using count function but doest work as it's taken every value and also I need summarize those values, means, the table B below should be the final table.
I have Table A and I need to get table B by extracting the info from table A to table B taking into account only unique values of the invoice column
Table A
Invoice | Actual | Standard |
A221 | 20 | 50 |
A221 | 50 | 30 |
A221 | 10 | 40 |
B334 | 45 | 10 |
B334 | 50 | 40 |
B3453 | 90 | 10 |
Table B
Invoice | Actual | Standard |
A221 | 80 | 120 |
B334 | 95 | 50 |
B3453 | 90 | 10 |
Thank you very much!
Solved! Go to Solution.
the following will return a table you want:
Summary Table =
SUMMARIZECOLUMNS(
'Table'[Invoice],
"Actual Total", SUM('Table'[Actual]),
"Standard Total", SUM('Table'[Standard])
)
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI Reportingthe following will return a table you want:
Summary Table =
SUMMARIZECOLUMNS(
'Table'[Invoice],
"Actual Total", SUM('Table'[Actual]),
"Standard Total", SUM('Table'[Standard])
)
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingHi Edhans,
This works perfectly well! Thanks a lot!! You're a genius
Enjoy your day!
@manuelfigueira wrote:You're a genius
Ha! No.
Coincidenally earlier this week I was working on a similar project and it took me about an hour to get a measure working right for me, and one of the components was a similar use of the SUMMARIZECOLUMNS() function. If you'd have asked last week, I might not have been the guy to answer. 😁
Glad your project is moving forward.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingCovering 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 |
---|---|
117 | |
107 | |
69 | |
68 | |
43 |
User | Count |
---|---|
148 | |
103 | |
103 | |
88 | |
66 |