Forum Discussion

ljimenezvega84's avatar
ljimenezvega84
Helper I
10 months ago
Solved

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 ( revenue = CALCULATE( SUM(Ammount), FILTER(table', 'GL Account= "1010")). Its possible...
Need Help
  • ajaybabuinturi's avatar
    ajaybabuinturi
    10 months ago

    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.

ajaybabuinturi's avatar
ajaybabuinturi
Super User
10 months ago

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.