Forum Discussion
Yaro
3 years agoFrequent Visitor
Summarize doesnt work on var table
Hi. Please help me with following. I have multiple tables (2 as example) from direct Power BI query - I need to consolidate them. So my idea is to select data I need, UNION it and then summarize i...
- 3 years ago
Yaro , Try group by in this case
Check the Dax solution
https://medium.com/@amitchandak/power-bi-power-query-vs-dax-append-and-summarize-data-233f173d0839
amitchandak
Super User
3 years agoYaro , Try group by in this case
Check the Dax solution
https://medium.com/@amitchandak/power-bi-power-query-vs-dax-append-and-summarize-data-233f173d0839
- Yaro3 years agoFrequent Visitor
thank you amitchandak
I need distinctcount, so it worked with a bit of workaround - Yaro3 years agoFrequent Visitor
hi amitchandak
got stuck again
it works like a charm when there is one measure to be summarized
but when I am adding additional column to be summarized it gives me an errorreturn groupby(UnitedTable2, [Site], [CalDate], "MonitoringsNum",COUNTX(CURRENTGROUP(),[CallIDString]), "ComplCriticalScore",SUMX(CURRENTGROUP(),[ComplCrit Score %]) )It workins perfectly fine with COUNTX but SUMX gives an error
"The CALCULATE function cannot be used in an expression argument for the GROUPBY function"Please suggest.
Thank you