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
Hi danextian,

Ohhh. I get it. Is the a way to fix this? I need to count distinct outlets with the billing type of ZRSS. Row values are correct its just that the total of the column did not match to the individual values in the rows.

Thanks
danextian's avatar
danextian
Super User
6 years ago

Hi Anonymous ,

 

You may try Anonymous 's formula. SUMMARIZE() creates a virtual table of count of unique outlet name for each tag  within the measure itself and SUMX sums up the count. Or you may create a calculated column that concatenates tag and outlet name columns and use that in your distinctcount measure instead.