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.

Hi andrieskoo 

what are the matrix columns from -20 to 20? Are they values in a column in your data or measures? What are the columns invloved in the rows of your matrix visual? Please provide sample data with the code of your measure(s). 

tamerj1 ,
columns from -20 to 20 is value from another table (not in relationship with table witch have column "Kod"), and it is measure 

and one of measure wich is related to earch column is

And I calculate this value (for earch temperature) adding column "Temperatura zewn." to wisualization

andrieskoo 

what is under "kod" in the matix hierarchy?

tamerj1 ,
it could be deleted

I need only this max value for "Kod" columns, all this temperature (-20 to 20) could be hiden

pehaps, I must calculate "x_pompy" in measure, witch calculate max value, but I do not know how

I calculate, but how calculate all in measure, not adding "Temperatura zewn" colunm to wizualization?

Because when I remove column "Temperatura zewn" result of measure gone (they are based on this temperature)

How to display same result without Temperatura zewn kolumn in visualization?