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)))

     

     

     

Anonymous's avatar
Anonymous
Not applicable
6 years ago

I have managed to include all dates with no transactions for assets. However, the formular you provided still calculates the max average turnover/availability ratio for each individual asset. I would need the highest ratio amongst all assets. Thoughts?

Anonymous's avatar
Anonymous
Not applicable
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)))