Filtered SUM

[hafchez]

Hi,

I'm new to power BI. I have a problem which I need to calculate and show the result of the amount from multiple ID with each filtered column. Can anyone assist me?

Here is the table. For example, I need to calculate amount only for ID which Transaction_Type is Buy Physical, Transaction_Category is Physical Gold and Transaction_Status are Paid and Withdrawn. Example, UserID is 00AB. After filtered the needed data, the amount should be 1.3955

[Greg_Deckler · Accepted solution]

@hafchez Try something like:

Measure =
  VAR __Table = 
    FILTER(
      'Table',
      [Transaction_Type] = "Buy Physical" &&
      [Transaction_Category] = "Physical Gold" &&
      ( [Transaction_Status] = "Paid" || [Transaction_Status] = "Withdrawn"
    )
RETURN
  SUMX(__Table,[Transaction_Amount])