Forum Discussion

i_kafali's avatar
i_kafali
Helper II
8 years ago

SELECTCOLUMNS does not return correct values from existing table

Hello,   I have an existing table called OK_INVOICE_ALL_EXCEL. so i have created new table called PARETO to make more lean table.   To create PARETO table i used below formula   PARETO = SELECT...
Need Help
Show and Tell
Tips and Tricks
tex628's avatar
tex628
Community Champion
8 years ago

From what i can tell your "PARETO" table is a combination of columns from the OK_INVOICE_ALL_EXCEL table and four different measures. Is it only the measure values that display incorrect values?

 

"volume (ton)";[Volume (ton)];
"Turnover";[TurnoverPV];
"FP1";[FP1];
"FP2";[FP2]

 

i_kafali's avatar
i_kafali
Helper II
8 years ago

No tex, all value measures returns incorrect values. as G has incorrect volumes as well as turnover, FP1 and FP2

  • i_kafali's avatar
    i_kafali
    Helper II
    8 years ago

    Btw all those volume, turnover, FP1 and Fp2 is calculated new measure from existing table. not coming from original data set.

    • tex628's avatar
      tex628
      Community Champion
      8 years ago

      Can you provide the dax forumla for one of the four measures?

      • i_kafali's avatar
        i_kafali
        Helper II
        8 years ago

        Sure,

         

        Thank you for reaching me out btw

         

        Volume (ton) =
        CALCULATE(
        SUM('OK_INVOICE_ALL_EXCEL'[Volume (t)]);
        'OK_INVOICE_ALL_EXCEL'[FAT_TIP (groups)] IN { "Count" }
        )

         

        TurnoverPV = (SUM(OK_INVOICE_ALL_EXCEL[DUSD_PV])+SUM(OK_INVOICE_ALL_EXCEL[IADE_USD])+SUM(OK_INVOICE_ALL_EXCEL[dgr_gel1]))/1000

         

        FP1 = OK_INVOICE_ALL_EXCEL[TurnoverPV]+OK_INVOICE_ALL_EXCEL[Raw Material]+OK_INVOICE_ALL_EXCEL[Packaging]+OK_INVOICE_ALL_EXCEL[Logistics]+OK_INVOICE_ALL_EXCEL[Commission] 

         

         

        FP2 = ([FP1]+[Depreciation Cost]+[Conversion Cost]+[Invent. Mov.])