Issue with calculating sum when matching text criteria in filter

Question

I am facing an issue here to calculate sum while matching a text in Power BI, below is the query I wrote. My table has data like Month and value associated with it, I want to dynamically calculate the sum as dates changes. I want to extract the Month from the date and match it with the lookup table and calculate the sum.

I am unsure what should I do here, when I use the below formula I'm getting blank values. Any help is much appreciated.

Current Month Quota =

VAR current_month = FORMAT(TODAY(), "MMMM") 
//--I even used convert function to convert it to string.

Return
CALCULATE(
    SUMX('RSD Quota', 'RSD Quota'[Target Value]), 
    'RSD Quota'[Month] = current_month
)

Answer 1

Try this below code-

Current Month Quota =

VAR current_month = FORMAT(TODAY(), "MMMM") 

Return
CALCULATE(
    SUM('RSD Quota'[Target Value]),
    FILTER(
        ALL('RSD Quota'),
        'RSD Quota'[Month] = current_month
    )    
)