Forum Discussion
Double filter formula
Hello, i´ve have a dataset just like this below. i just created a formula to optain the Ammount by GL Account (
| GL Account | Type | Cost Center | Month | Ammount |
| 1010 | Actual | xxx | 01/2025 | 10.000 |
| 1020 | Plan | xxx | 01/2025 | 20.000 |
| 1010 | Past year | xxx | 01/2025 | 30.000 |
| 1020 | Actual | xxx | 01/2025 | 40.000 |
Hi ljimenezvega84,
Yes, you can able to add multiple filters in the CALCULATE DAX function. Refer syntax: CALCULATE(<expression>[, <filter1> [, <filter2> [, …]]])
revenue plan = CALCULATE( SUM(Ammount), FILTER(table', 'GL Account= "1010"), FILTER(table', 'Type= "Plan"))
revenue actual = CALCULATE( SUM(Ammount), FILTER(table', 'GL Account= "1010"), FILTER(table', 'Type= "Actual"))Thanks,
If you found this solution helpful, please consider giving it a Like👍 and marking it as Accepted Solution✔. This helps improve visibility for others who may be encountering/facing same questions/issues.
1 Reply
Hi ljimenezvega84,
Yes, you can able to add multiple filters in the CALCULATE DAX function. Refer syntax: CALCULATE(<expression>[, <filter1> [, <filter2> [, …]]])
revenue plan = CALCULATE( SUM(Ammount), FILTER(table', 'GL Account= "1010"), FILTER(table', 'Type= "Plan"))
revenue actual = CALCULATE( SUM(Ammount), FILTER(table', 'GL Account= "1010"), FILTER(table', 'Type= "Actual"))Thanks,
If you found this solution helpful, please consider giving it a Like👍 and marking it as Accepted Solution✔. This helps improve visibility for others who may be encountering/facing same questions/issues.