DAX query question / performance issue

lbendlin  thanks for your reply.

There is one Fact Table, one Dimension Table. Connected with a many to many relationship via a key.

Of course, there are some more Dimensions, but they are not relevant for this report.

With the query builder in DAX Studio i was able to generate the following query.

MyMessure1 just contains a simple calculation of some columns on the fact table. This works as expected.

The result is correct, so far.

What i now whant to do is: multiply RATE with MyMeasure. In a final step i want to get the SUM of those results by customer_code. In this case i would expect the following result:

As i already wrote in the topic, i found a solution for doing that. But this is really really slow.

Kind regards

Jack