Double filter formula

[ljimenezvega84]

Hello, i´ve have a dataset just like this below. i just created a formula to optain the Ammount by GL Account (

revenue = CALCULATE( SUM(Ammount), FILTER(table', 'GL Account= "1010")). Its possible to add ahother filter and obtain GL Account and Type  (need to obtain Actual revenue, Plan revenue, etc).

Thanks

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

[ajaybabuinturi · Accepted solution]

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.