Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to 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])
@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])
User | Count |
---|---|
54 | |
22 | |
19 | |
16 | |
11 |
User | Count |
---|---|
81 | |
55 | |
39 | |
20 | |
12 |