Forum Discussion

ashwani_pal's avatar
ashwani_pal
Helper I
8 years ago
Solved

SUMX Function

Hi,    I am using Sumx Function  to calculate selective data in Power BI report using SUMX as a query in  adding custom column. But It is showing error "Expression.Error: The name 'SUMX' wasn't rec...
Need Help
Tutorial Requests
  • v-jiascu-msft's avatar
    v-jiascu-msft
    8 years ago

    Hi ashwani_pal,

     

    Seems you were using a DAX function in the Query Editor that only accepts Power Query formula language (M language) and R. Please try it out in the Data pane.

    SUMX_Function

     

    Best Regards,

    Dale

ashwani_pal's avatar
ashwani_pal
Helper I
8 years ago

Thanks for quick reply,

I need to filter columns from 2 different tables by compairing there values and whichever rows are remaining after filtering, i need to aplly mathematical operation (summation.) Query i am using is : 

 

 

sumx(filter("ERTTReports_RuntimeLifetime_SHIFT", "ERTTReports_RuntimeLifetime_SHIFT.Asset" = [Asset], AND
( "ERTTReports_RuntimeLifetime_SHIFT.StartTime" >=[Time],"ERTTReports_RuntimeLifetime_SHIFT.StartTime" <=[Next Time]),
("ERTTReports_RuntimeLifetime_SHIFT.EndTime">=[Time]and "ERTTReports_RuntimeLifetime_SHIFT.EndTime"<=[Next Time])),
"ERTTReports_RuntimeLifetime_SHIFT.Duration")

 

Regards

Ashwani

Ashish_Mathur's avatar
Ashish_Mathur
Super User
8 years ago

Hi,

 

Share some data and show the expected result.