Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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 |
---|---|
48 | |
44 | |
19 | |
14 | |
14 |
User | Count |
---|---|
107 | |
57 | |
29 | |
20 | |
16 |