Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

DAX SUM HELP

  Ho can I calculate the sum of Qty in GRN. QTy in GRN is repeating for each line item, but i need to take the value once per each document no. Please help on this?  
Need Help
  • v-kelly-msft's avatar
    v-kelly-msft
    6 years ago

    Hi Anonymous ，

     

    You can use the measure below:

     

    Measure 2 =
CALCULATE (
    SUMX (
        SUMMARIZE (
            'Table (2)',
            'Table (2)'[No_],
            "total", SUMX ( DISTINCT ( 'Table (2)'[Qty_ in Gen] ), 'Table (2)'[Qty_ in Gen] )
        ),
        [total]
    ),
    FILTER ( 'Table (2)', 'Table (2)'[QC Result] = "Accepted without Deviation" )
)

    Best Regards,

    Kelly

RobbeVL's avatar
RobbeVL
Icon for Impactful Individual rankImpactful Individual
6 years ago

Hi there,

 

What is your expected result?

The easiest way to solve your problem is to take the Average, instead of the sum. 

This way, the total will be the same number per Item.

 

Let me know if this helped.

Robbe

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Not possible, its showing wrong data with conditions.

  • RobbeVL's avatar
    RobbeVL
    Icon for Impactful Individual rankImpactful Individual
    6 years ago

    Hi,

     

    What is your expected result ? 

     

    Robbe

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

       

      I need the sum of qty based on the document number and result.

      • AnthonyTilley's avatar
        AnthonyTilley
        Icon for Solution Sage rankSolution Sage
        6 years ago

        can you please provide this data as a table instead of an image