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,

     

15 Replies

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

        DISTINCTCOUNT() counts the unique values. In your total, it counts the unique values in [Outlet Name] in the current filter context which is [Billing Type]="ZRSS" and two or more tags may be sharing the same Outlet Name and that Outlet Name is counted as one only in the total.