Forum Discussion

Crydus's avatar
Crydus
Icon for Helper I rankHelper I
6 years ago
Solved

Get sum in table visual where some values are only count once

Hey there,  I am reaching the end of my (still very limited) Power BI knowledge. I am currently creating a quality measure report where with a table visual which shows the amount of defect pieces ...
Need Help
  • nandukrishnavs's avatar
    nandukrishnavs
    6 years ago

    Hi Crydus,

    Please try below the DAX measure.

     

    SumOfDefectParts =
VAR summarizedTable =
    CALCULATETABLE (
        SUMMARIZE (
            'Table',
            'Table'[ComplaintNo],
            'Table'[Item],
            "DefectPartsValue", MIN ( 'Table'[Defect Parts] )
        )
    )
VAR result =
    SUMX ( summarizedTable, [DefectPartsValue] )
RETURN
    result

     

    Let me know if you are finding any issues. 

     

     

    Regards,

    Nandu Krishna

     

nandukrishnavs's avatar
nandukrishnavs
Icon for Community Champion rankCommunity Champion
6 years ago

Hi Crydus,

Please try below the DAX measure.

 

SumOfDefectParts =
VAR summarizedTable =
    CALCULATETABLE (
        SUMMARIZE (
            'Table',
            'Table'[ComplaintNo],
            'Table'[Item],
            "DefectPartsValue", MIN ( 'Table'[Defect Parts] )
        )
    )
VAR result =
    SUMX ( summarizedTable, [DefectPartsValue] )
RETURN
    result

 

Let me know if you are finding any issues. 

 

 

Regards,

Nandu Krishna

 

Crydus's avatar
Crydus
Icon for Helper I rankHelper I
6 years ago

This seems to be perfect. 
Now I have to only find out, why there is a difference of 2 between this measure and my old calculations but I'm pretty sure that this is due to my calculations. 

Thank you!