Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Creating table out of 1 value through DAX

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 on...
Need Help
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
7 years ago

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's avatar
    Anonymous
    Not applicable
    7 years ago

    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's avatar
      Greg_Deckler
      Icon for Community Champion rankCommunity Champion
      7 years ago

      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's avatar
        Anonymous
        Not applicable
        7 years ago

        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