Forum Discussion
Creating table out of 1 value through DAX
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
Community ChampionOK, let me try a different track, what do you expect the results should be for the data provided? If not 10, then what?
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
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
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