Forum Discussion

Anonymous

Not applicable

6 years ago

Solved

Sum on Max value

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
6 years ago
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-trend/ba-p/882970

3 Replies

smpa01
Community Champion
6 years ago
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
  Not applicable
  6 years ago
  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
amitchandak
Super User
6 years ago
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-trend/ba-p/882970