SUMX of a MAXX variable

[Anonymous]

Hello to everyone,

do you have an idea how i can sum the max variable:

=VAR FilterRow = FILTER('Query_NIKKEI_225';'Query_NIKKEI_225'[timestamp]=EARLIER('Query_NIKKEI_225'[timestamp]) && EARLIER('Query_NIKKEI_225'[Differenz Datum])>=0)
VAR FilterRow2 = FILTER('Query_NIKKEI_225';EARLIER('Query_NIKKEI_225'[Differenz Datum])>=0)
VAR yStern =MAXX(FilterRow;LN(Query_NIKKEI_225[(high + low )/2]))
VAR ySternQuer = AVERAGEX(FilterRow2;LN(Query_NIKKEI_225[(high + low )/2]))
VAR ySternMinusySternQuer = MAXX(FilterRow;yStern-ySternQuer)
VAR xStern =MAXX(FilterRow;'Query_NIKKEI_225'[Rang Datum])
VAR xSternQuer = AVERAGEX(FilterRow2;'Query_NIKKEI_225'[Rang Datum])
VAR xSternMinusxSternQuer = MAXX(FilterRow;xStern-xSternQuer)
VAR xMinusxQuerMalySternMinusySternQuer=MAXX(FilterRow;xSternMinusxSternQuer*ySternMinusySternQuer)
Return
SUMX(FilterRow2;CALCULATE(MAXX(FilterRow;xSternMinusxSternQuer*ySternMinusySternQuer)))

[dax]

Hi Friedrich, 

I can't just based on your expression to reproduce your design, so if possible, could you please inform me more detailed information (such as your sample data and your expected output)? Then I will help you more correctly.

Best Regards,
Zoe Zhi

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hello,
thank you for your message. If I want to update the datamodell I get the error shown below.
In German it is called "Ringabhängigkeit" / A circular dependency was detected. 
Now I want to solve the Problem that way, that I write everything in one measure.
I want to calculate the linear regression and the exp Regression. The Formular calcualte the Right result, but I can not update the datamodell.
May you can help?
Best regards

Error MessageDatamodell part 1Datamodell part 2Datamodell part 3

[dax]

Hi Friedrich,

It seems that you want to transform calculated column to measure, right? You said that you can't upload the data sample, I think you could use simple data sample like below to explain your logic and expected output. Then I will help you more correctly.

name	amount	id
a	2	1
b	5	1
c	10	1
a	16	2
b	15	2
c	12	2

Please do mask sensitive data before uploading.

Thanks for your understanding and support.
Best Regards,
Zoe Zhi

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hello,
i still get the error message. You can find the link below. Maybe you find what i am doing wrong.
Best regards
https://www.dropbox.com/s/ejviiqquktg56x1/Dashboard_NIKKEI_225.xlsx?dl=0

[dax]

Hi Friedrich,

I could get your sample, but I still have confusion about something in your sample and expression, I didn't find the "Query_NIKKEI_225'[Differenz Datum]" in your data, and if possible, could you please explain your logic of your requirement(sumx of maxx variable) and your expected output(by drawings or screenshots)?

Please do mask sensitive data before uploading.

Thanks for your understanding and support.
Best Regards,
Zoe Zhi

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hello,
"Differenz Datum" is the third calculated column in the Data Modell. I can not update the data modell because of "A circular Dependency was detected". I think this is the real question: How i can handle this error message.
In the data modell i calculate two regression. The formulas work right, but i can not update the data modell.
Best regards

[Anonymous]

Hello to everyone,

I solved the rpoblem with power query.

Best regards

[dax]

Hi Friedrich,

It seems that you solve this problem, right?If so and if you'd like to, you could mark corresponding post as answer or share your solutions. That way, people who in this forum and have similar issue will benefit from it.

Best Regards,
Zoe Zhi

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.