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

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