Forum Discussion

Anonymous's avatar
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,Job...
Need Help
smpa01's avatar
smpa01
Icon for Community Champion rankCommunity 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's avatar
    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