Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Total Column Sum is not equal

Hi everyone! I've been stuck with this, hope you can help me. Thanks! The Total Sum should be 475.        
Need Help
Show and Tell
Tips and Tricks
  • v-lid-msft's avatar
    v-lid-msft
    6 years ago

    Hi Anonymous ,

     

    We suggest you to delete your shared report link in your reply if it contain any confidential information, We can also use the following measure to meet your requirement:

     

    B2B OUTLET BUYING =
SUMX (
    DISTINCT ( 'SUB TYPES'[Tag] ),
    CALCULATE (
        DISTINCTCOUNT ( [Outlet Name] ),
        'TOTAL SALES DATA'[Billing Type] = "ZRSS"
    )
)


    Best regards,

     

Anonymous's avatar
Anonymous
Not applicable
6 years ago
B2B OUTLET BUYING = CALCULATE(DISTINCTCOUNT([Outlet Name]),'TOTAL SALES DATA'[Billing Type]="ZRSS") Here
dethompson97's avatar
dethompson97
Resolver III
6 years ago

Can you also share your data model?  What is [Outlet Name]?  By convention, it should be a measure but I am not sure it is.

 

Thanks!

DAwn

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago
    Try this NewMeasure = SUMX(SUMMARIZE('TOTAL SALES DATA','SUB TYPES'[Tag],"total",[B2B OUTLET BUYING]),[total])

    The issue you faced because of incorrect parenthesis.

    Thanks
    Pravin
    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago
      Try the measure which i have corrected.
  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Here,

     

     

    • v-lid-msft's avatar
      v-lid-msft
      Community Support
      6 years ago

      Hi Anonymous ,

       

      We suggest you to delete your shared report link in your reply if it contain any confidential information, We can also use the following measure to meet your requirement:

       

      B2B OUTLET BUYING =
SUMX (
    DISTINCT ( 'SUB TYPES'[Tag] ),
    CALCULATE (
        DISTINCTCOUNT ( [Outlet Name] ),
        'TOTAL SALES DATA'[Billing Type] = "ZRSS"
    )
)


      Best regards,

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        Hi v-lid-msft ,

         

        Noted on the deletion of link.

         

        And thank you! The formula works. Thank you very much

         

        Rey