Forum Discussion

i_kafali's avatar
i_kafali
Icon for Helper II rankHelper 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
Icon for Helper II rankHelper 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
Icon for Community Champion rankCommunity Champion
8 years ago

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

  • i_kafali's avatar
    i_kafali
    Icon for Helper II rankHelper 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
      Icon for Community Champion rankCommunity Champion
      8 years ago

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

       

      • i_kafali's avatar
        i_kafali
        Icon for Helper II rankHelper II
        8 years ago

         

        Rex, both has 970.250 rows