Forum Discussion

Datafruit's avatar
Datafruit
Icon for Helper I rankHelper I
5 years ago
Solved

Measure to sum unique values in column with duplicate values based on a another column

Hi guys   Pretty new to PBI and have a problem with creating a measure, that does what I need it to do. Basically I have a table where I have a bunch of data and I need to sum "Transaction fee" col...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    5 years ago

    Datafruit Perhaps:

    Measure =
  VAR __Table = 
    DISTINCT(
      SELECTCOLUMNS('Table',"fee",[transaction_fee],"nr",[customer_nr],"country",[country])
    )
RETURN
  SUMX(__Table,[fee])
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
5 years ago

Datafruit Perhaps:

Measure =
  VAR __Table = 
    DISTINCT(
      SELECTCOLUMNS('Table',"fee",[transaction_fee],"nr",[customer_nr],"country",[country])
    )
RETURN
  SUMX(__Table,[fee])
  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    This solution looks like it will fit for my data issues as well, however I cannot get correct syntax to work for the Measure.  Can you help with the VAR command and when we say "Table" are we referring to the table with my data or some temporary table?