Group By function in Power BI DAX

I am trying to use Group By function in Power BI taking Direct Query through Denodo as my source.

Formula used is as below:

Table = GROUPBY(logistics_freight_audit_and_payment_fap, logistics_freight_audit_and_payment_fap[consolidated_load_id],logistics_freight_audit_and_payment_fap[consolidated_accounting_classification],"Manual",

SUMX(CURRENTGROUP(),logistics_freight_audit_and_payment_fap[freight_bill_break_down_amount_budget_rate_c]))

And on executing this formula, I am getting the below error: 

I tried using Summarize function instead of Group By and still getting the same error.

DAX