Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I have to filter " Claimed Amount" Column with two criteria.
I have entered Measure as below:
Remuneration Claimed (INR) = CALCULATE( sum('NKC MM'[Claimed Amount]), filter(all ('NKC MM'[CAT]), 'NKC MM'[CAT]= "B" && 'NKC MM'[CAT]= "C"))
The Filter does not show any value in the dashboard.
I want to filter "Claimed Amount" with Categories " B" AND "C" both
Can someone help!
Solved! Go to Solution.
This is a single column and to get both values B and C you need to use the OR operator (not AND)
You want the Column to be either "B "or "C" (but it can't be B and C at the same time - it can be only be B OR C one at a time)
Remuneration Claimed (INR) = CALCULATE ( SUM ( 'NKC MM'[Claimed Amount] ), FILTER ( ALL ( 'NKC MM'[CAT] ), 'NKC MM'[CAT] = "B" || 'NKC MM'[CAT] = "C" ) )
Hope this helps and makes sense!
This is a single column and to get both values B and C you need to use the OR operator (not AND)
You want the Column to be either "B "or "C" (but it can't be B and C at the same time - it can be only be B OR C one at a time)
Remuneration Claimed (INR) = CALCULATE ( SUM ( 'NKC MM'[Claimed Amount] ), FILTER ( ALL ( 'NKC MM'[CAT] ), 'NKC MM'[CAT] = "B" || 'NKC MM'[CAT] = "C" ) )
Hope this helps and makes sense!
Hi,
I have been trying to get a sum work with multiple criteria using the above example, and it's not working. I have tried both the following formulas. Both of these formulas are seem to be correct in desktop, meaning I am not getting an error on the actual syntax of these formulas.
This formula does give a result, however it is not the correct result.
Quality Sales = CALCULATE([Total Sales],
'Fact Agency Data'[Status] in {"Issue Paid", "Issue Paid|ARF", "Issue Paid|PDR", "Issued Paid|NY PIF", "Issued Paid|PDR|NY PIF" }
)
This formula doesn't return any results.
User | Count |
---|---|
128 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |