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...
  • 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])
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity 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])