Forum Discussion

hafchez's avatar
hafchez
Frequent Visitor
4 years ago
Solved

Filtered SUM

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's avatar
    Greg_Deckler
    4 years ago

    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])

1 Reply

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    4 years ago

    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])