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.
Solved! Go to Solution.
Hi,
Have you tried the below?
Revenue = CALCULATE(
Sum( Transactions[Amount]),
FILTER( Transactions,
Transactions[Account Type] IN {"Income", "Other Income"}
&& Transactions[Activity]="Dairy"
)
)
Hi,
Have you tried the below?
Revenue = CALCULATE(
Sum( Transactions[Amount]),
FILTER( Transactions,
Transactions[Account Type] IN {"Income", "Other Income"}
&& Transactions[Activity]="Dairy"
)
)
Hi @Ada_nnaya ,
Thanks for this. The card no longer shows (Blank).
However, for example, in 2020, the card shows 306,772,172/= as the result. When I check my table, that sum is from [Account Type]"Income" only.
Here is a snapshot of my data.
Sure @ghoshabhijeet .
See photo.
When I use the DAX @Ada_nnaya suggested though, I'm only getting sum for [Account Type]"Income"
Hi,
I would then check if there are trailing spaces in the Activity and Account Type columns. Any spaces or typos would prevent effective filtering.
User | Count |
---|---|
84 | |
84 | |
68 | |
62 | |
56 |
User | Count |
---|---|
137 | |
110 | |
92 | |
84 | |
69 |