Forum Discussion
Creating table out of 1 value through DAX
Community ChampionWhere 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.
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?
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