Sum filtered rows with calculation in between

Hi kaz5281 ,

I have created a simple sample, please refer to it to see if it helps you.

Create measures.

value_m = IF(MAX('Table'[Object])="ObjD",MAX('Table'[Value])*10,MAX('Table'[Value]))

Measure = DAY(EOMONTH(MAX('Table'[date]),0))

Measure 2 = 
var _b = SUMMARIZE('Table','Table'[Object],"aaa",[value_m])
return
IF(HASONEVALUE('Table'[Object]),[value_m],SUMX(_b,[aaa])/[Measure])

Measure 3 = 
var _b = SUMMARIZE('Table','Table'[Object],"aaa",[value_m])
return
IF(HASONEVALUE('Table'[Object]),[value_m],SUMX(_b,[aaa]))

How to Get Your Question Answered Quickly - Microsoft Fabric Community

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

Best Regards
Community Support Team _ Rongtie

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.