Calculate max value with conditions

Hi andrieskoo 

I've had a look at the file... Is this at all a PBI model or just a data dump? All the tables are disconnected in there, which makes me think the author does not yet fully understand the basic dimensional modeling principles Power BI is based on. My kind advice would be to first focus on some PBI theory, then on building a good dimensional model (which is always crucial to producing good correct numbers) and then on starting writing correct measures. As it currently stands, this solution will fall apart sooner than anyone thinks.