Forum Discussion

markefrody's avatar
markefrody
Icon for Post Patron rankPost Patron
8 years ago

Using DAX: Removing Duplicates in Column A Before Summing Up Column B

Hi,   I would like to ask you assistance if there is a DAX query that could help me on the below. Please note that I cannot use remove duplicates in "Edit Queries" since I have other calculations t...
Need Help
Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi markefrody,

 

You can create a new DAX table with this formula:

 

NewDAXTable =
SUMMARIZECOLUMNS (
    'Table'[Job: Name],
    "Sum_SPHA_Filled", MAX ( 'Table'[SPHA's Filled] )
)

Regards.

  • markefrody's avatar
    markefrody
    Icon for Post Patron rankPost Patron
    8 years ago

    Hi Anonymous,

     

    Thanks for the suggestion. Is it posibble to group it also via "Office"?