Forum Discussion
maximum value from table
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
Hi Syndicate_Admin It gets filtered if you select any value and it gives max of selected date. If you need max irrespective of selected date then you can write measure as below:-
measure = calculate(Max(table[energydata_value]),All(table))
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?
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