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
Anonymous's avatar
Anonymous
Not applicable
6 years ago
Try this
Sumx(summerize(table,table[column]"total",[b2b outlet]),[total])

Thanks,
Pravin
  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi, I'm sorry, I'm very new at Power Bi.

     

    Can I send the link of my dashboard instead?

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago
      Go to power bi desktop

      Click on home then click on meausre
      Write the above dax
      And add that measure and required column to table visual.


      Note :change the column and table names as per requirement.
      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago
        NewMeasure = SUMX(SUMMARIZE('TOTAL SALES DATA','SUB TYPES'[Tag],"total",[B2B OUTLET BUYING],[total]))
         
        result was "Too few arguments were passed to the SUMX function. The minimum argument count for the function is 2."