Sum on Max value

[Anonymous]

Hi there,

I have a measure  (I created Commulative total in SQL table) 

Gross Billing_C = Calculate(

max(BillingStatus[INV_AMT_C]) - max(BillingStatus[IMEMO_AR_AMT_C]),

Filter(JobComplete,JobComplete[YER] = SELECTEDVALUE(BillingStatus[YER])),

Filter(JobComplete,JobComplete[PER] = SELECTEDVALUE(BillingStatus[PER])),

filter(AR_AgedReport,AR_AgedReport[CJKEY] <> "")

)

This measure works fine but when it shows in a table(multiple rows) the total is not accurate 

It shows the Max value of whatever row is max value and not the sum of all rows

How do I solve it? - another word how to make table TOTAL sows sum regardless if it MAX or MIN in the rows

Thanks

Oded Dror

[amitchandak · Accepted solution]

Refer this :https://community.powerbi.com/t5/Desktop/SUM-of-AVERAGE/td-p/197013

If it does not help.

Can you share sample data and sample output. If possible please share a sample pbix file after removing sensitive information.Thanks.

My Recent Blog -

https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...

[smpa01]

@Anonymous  is there any chance you can provide a small sample that is representative all the columns used in your measure as well as a column with your desired output. Hard to devise a solution otherwise.

[Anonymous]

Hi there,

Thank you for the response my problem was (I found that later) I had multiple periods that way the summation wase't correct.

After I fix that it return the expected results. 

My whish list is to get total on matrix regardless if it is Max, Min Avg or any other cumputation like the table visual

Thanks,

Oded Dror