Creating table out of 1 value through DAX

[Anonymous]

Hello everyone!
I have stucked with the dax formulas. Here is the situation:
1. We have only 1 variable value that is used to create all other columns, and two columns to interact with.

2. That one variable sets as a What IF parameter

3. I tried to used SUM instead of SUMX but got wrong results in total, which is not acceptable 

4. I tried to create "Virtual Table" out of table of clean values to count others (New Table button (SUMMURIZECOLUMNS...)), didnt work - got all values which comes from measures equal 0

Yellow marked columns are constant they are not affected by "Value1" (on top)

and the last column - "Value1_for_reciept = SUMX('Table1';'Table1'[Sum Value] / 'Table1'[Reciept value])" i was waiting 23,49*2,35 which is equal to 10 but i get "Average_values" somehow

Here is the example file

https://onedrive.live.com/embed?cid=32B05E6328809814&resid=32B05E6328809814%211741&authkey=AHdHMH8ih...

Thanks in advance for your answers.

EDIT:

Ok. Maybe it will help. I have some data

I need this data to manipulate with what if parameter in dax, called "Value"

I need this "Value" first be multiplied by share_Value1 here it is "Sum Value"

Next I need two columns that containe "Sum Value" divided by average_Value1 and they are "Receipt Value" and "Offer Value"

Then I need to multiply Sum_Value by Reciept_Value to get "Value1_for_receipt" and here is all going wrong.

Same story with another Reciept_Value*average_price it also returns not what I expect to see

[Anonymous]

Ok. Maybe it will help. I have some data

I need this data to manipulate with what if parameter in dax, called "Value"

I need this "Value" first be multiplied by share_Value1 here it is "Sum Value"

Next I need two columns that containe "Sum Value" divided by average_Value1 and they are "Receipt Value" and "Offer Value"

Then I need to multiply Sum_Value by Reciept_Value to get "Value1_for_receipt" and here is all going wrong.

Same story with another Reciept_Value*average_price it also returns not what I expect to see

[Greg_Deckler]

Where are you getting "Average values"? So the 10 in the first row is correct or not correct? Are you referencing your Total line? Please clarify.

[Anonymous]

Average values - these are constant they come from excel table, total line of average valueas is also correct, total line would be incorrect to my opinion if i use SUM instead of SUMX in table

[Greg_Deckler]

OK, let me try a different track, what do you expect the results should be for the data provided? If not 10, then what?

[Anonymous]

Ok. Maybe it will help. I have some data

I need this data to manipulate with what if parameter in dax, called "Value"

I need this "Value" first be multiplied by share_Value1 here it is "Sum Value"

Next I need two columns that containe "Sum Value" divided by average_Value1 and they are "Receipt Value" and "Offer Value"

Then I need to multiply Sum_Value by Reciept_Value to get "Value1_for_receipt" and here is all going wrong.

Same story with another Reciept_Value*average_price it also returns not what I expect to see

[Anonymous]

Ok. Maybe it will help. I have some data

I need this data to manipulate with what if parameter in dax, called "Value"

I need this "Value" first be multiplied by share_Value1 here it is "Sum Value"

Next I need two columns that containe "Sum Value" divided by average_Value1 and they are "Receipt Value" and "Offer Value"

Then I need to multiply Sum_Value by Reciept_Value to get "Value1_for_receipt" and here is all going wrong.

Same story with another Reciept_Value*average_price it also returns not what I expect to see

[Anonymous]

Greg, in column "Average values" evrything is correct, errors happens when I use the SUMX measure in next measures, they are kind of nested

>> "Value1_for_reciept = SUMX('Table1';'Table1'[Sum Value] / 'Table1'[Reciept value])" i was waiting 23,49*2,35 which is equal to 10 but i get "Average_values" somehow