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

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

hi | Microsoft Fabric Community

3 Replies

mangaus1111
Solution Sage
3 years ago
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
  Solution Specialist
  3 years ago
  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
  
  Title.pbix8.8 MB
  - abc_777
    Solution Specialist
    3 years ago
    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
    test.pbix31 KB

Forum Discussion

hi