Filtered SUM

hafchez — Tue, 10 May 2022 10:48:00 GMT

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

Re: Filtered SUM

Greg_Deckler — Tue, 10 May 2022 10:59:41 GMT

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

topic Re: Filtered SUM in DAX Commands and Tips

Filtered SUM

Re: Filtered SUM