Forum Discussion
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...
Btw all those volume, turnover, FP1 and Fp2 is calculated new measure from existing table. not coming from original data set.
Can you provide the dax forumla for one of the four measures?
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.])