hi

[abc_777]

Hi

Hello some one please help me why i am getting this total

is this a measure switching. from Piece to KG 

Total Quantity in KG (Measure) =

(SUM('bm_retail_t sale'[SQTY])

        - SUM('bm_retail_t sale'[RQTY])) * SUM('BM Product List'[Weight in (KG)])

also tried 

Total Quantity in KG (Measure) =

CALCULATE

(SUMX

    ('bm_retail_t sale', ('bm_retail_t sale'[SQTY]

        -'bm_retail_t sale'[RQTY])) * SUM('BM Product List'[Weight in (KG)])

Total Quantity in Piece (Measure)

CALCULATE

(SUMX

    ('bm_retail_t sale', ('bm_retail_t sale'[SQTY]

        -'bm_retail_t sale'[RQTY])))

please help me out

[mangaus1111]

Hi @abc_777 ,

I don´t know, maybe you can correct the total creating an additive measure like this:

SUMX(
    VALUES('Table'[ITEM_NAME]),
    [YourMeasure]
)

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[abc_777]

this is just a simple calculation. I can not type values as item name as i use this measure to other visualisations as well. like product departmenr, or product category or customer product purchased etc.

This measure is generic to use piece and KG

I attached sample file. please see the sheet name 

Piece and KG

my total or grand total are not correct. please help me what is the issue

[abc_777 · Accepted solution]

here i chare another file. my total is incorrect. and i want generic measure to use as product department, product name product category , customer purchase etc.

please help me