Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Max of a Calculated Measure

Hi,   I have the following situation: I have two tables with information on assets. The two tables are linked via two tables: [Date Table] and a Table containing information on every asset [Asset I...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    Update: I have changed the data structure slightly by creating one table that holds all information on turnover and uptime  by Date and Asset and was then able to calculate the maximum of the average using this code:

     

     

     

     

    Maximum of averages = CALCULATE(MAXX(
	KEEPFILTERS(VALUES(Table[Asset])),
	CALCULATE(AVERAGE(Table[Turnover]))
), ALLSELECTED('Asset information'), ALLSELECTED(Date Table)))