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
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.])

      • tex628's avatar
        tex628
        Community Champion
        8 years ago

        Quick question, if you compare your PARETO table to your original table, does the row count differentiate?