Help with Grouping Values

[richardwg]

Hi Everyone, 

I need help trying to figure out a group by function or some other function that will allow me to sum the total HashrateAVG for a specefic 'LCDName' in the data table below, where 'ASC' can be repeated multiple times for LCD name and I only need it summed once. For example in the case below for 'LCDName' 2324 it should return 72.015 (11.86+25.28+34.87).

I've tried this and keep getting a error.

HR by server =

 VAR HR_Server =

    GROUPBY('WM HB Data','WM HB Data'[Date],'WM HB Data'[LCD Name],'WM HB Data'[Asc],

        "HashrateAvg", MAX(CURRENTGROUP(),MAX('WM HB Data'[HashrateAvg])))

RETURN

MAX(HR_Server, MAX([HashrateAvg]))

[ryan_mayu · Accepted solution]

@richardwg 

1. you can remove duplicates in PQ, that will be easier for you to calculate

2. or you can try this

Table 2 = 
var tbl=ADDCOLUMNS('Table',"average",'Table'[Avg]/CALCULATE(COUNTROWS('Table'),FILTER('Table','Table'[date]=EARLIER('Table'[date])&&'Table'[LCD NAME]=EARLIER('Table'[LCD NAME])&&'Table'[Avg]=EARLIER('Table'[Avg]))))
return SUMMARIZE(tbl,[date],[LCD NAME],"output",sumx(FILTER(tbl,'Table'[date]=EARLIER('Table'[date])&&'Table'[LCD NAME]=EARLIER('Table'[LCD NAME])),[average]))

pls see the attachment below