Forum Discussion
maximum value from table
Hi all, can anyone help me, i have been trying to extract the maximum value from this table, yet i was unable to do so. Is there any tricks or code that could help ? Thanks
Hi Anonymous ,
You can try to update the formula of measure [maxxx] as below and check whether you can get the correct value. Please find the details in the attachment.
maxxx = CALCULATE ( MAX ( 'energykwh energydata'[energydata_value] ), ALLSELECTED ( 'energykwh energydata' ) )Best Regards
I still cant get pass through with that coding. May i know what i should put as table?
The highlighted value is the maximum value while the blue pointed pen is max value, and its not the same.
Anonymous , could you please elaborate what should be expected output?