Forum Discussion

Yaro's avatar
Yaro
Frequent Visitor
3 years ago
Solved

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...
DAX help needed
Yaro's avatar
Yaro
Frequent Visitor
3 years ago

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 error

return 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