topic Re: Calculate max value with conditions in DAX Commands and Tips

Calculate max value with conditions

andrieskoo — Sun, 03 Apr 2022 18:28:53 GMT

Hi,
I have a problem with calculating max value witch is in special condition.

Expected result column x

all value between columns -20 till 20 calkulating by measure depending from t (is column in tale) and I want to calculate value in column x wich is a max value in row and must be > than value column and < than value from next column, else is 10

Re: Calculate max value with conditions

tamerj1 — Sun, 03 Apr 2022 20:08:30 GMT

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

Re: Calculate max value with conditions

andrieskoo — Sun, 03 Apr 2022 20:22:48 GMT

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

Re: Calculate max value with conditions

tamerj1 — Sun, 03 Apr 2022 20:57:26 GMT

andrieskoo

what is under "kod" in the matix hierarchy?

Re: Calculate max value with conditions

andrieskoo — Sun, 03 Apr 2022 21:11:41 GMT

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

Re: Calculate max value with conditions

andrieskoo — Sun, 03 Apr 2022 21:58:13 GMT

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)

Re: Calculate max value with conditions

tamerj1 — Mon, 04 Apr 2022 03:24:07 GMT

Hi andrieskoo
One option is to have this value in the rows grand total of your original matrix

You can use a new measure

New Measure = IF ( HASONEVALUE ( _Budynek[Temperatura zewn] ), [Fist Measure], [2nd Measure] )

Re: Calculate max value with conditions

andrieskoo — Tue, 05 Apr 2022 21:05:55 GMT

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

Re: Calculate max value with conditions

tamerj1 — Tue, 05 Apr 2022 21:13:52 GMT

Can you please share a sample file?

Re: Calculate max value with conditions

andrieskoo — Wed, 06 Apr 2022 10:58:14 GMT

tamerj1 ,
Here https://we.tl/t-zi4u0XfzHH

Re: Calculate max value with conditions

daXtreme — Wed, 06 Apr 2022 16:24:38 GMT

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.

Re: Calculate max value with conditions

tamerj1 — Wed, 06 Apr 2022 16:33:23 GMT

andrieskoo
I spent a while looking into it but apparently could not understand almost anything. That is beyond my capabilities. Apologies for not being able to serve you properly.