Forum Discussion

abc_777's avatar
abc_777
Solution Specialist
3 years ago
Solved

hi

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])       ...
Need Help
  • abc_777's avatar
    abc_777
    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

mangaus1111's avatar
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's avatar
    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

     

     

     

    • abc_777's avatar
      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