Create New Measure that Filters Current Measure to a Specific Year

[equevedo84]

Need assistance on syntax,  I have a measure Compliance % that exists in a Compliance Data table and has the following syntax:

Compliance % = [Compliant Mems]/[Eligible Mems]

Now I need to create two more measures that simply take Compliance % measure and filters to 2023 and 2024 from the Date table Year column in order to do YoY side by side comparisons in my visuals.

I apologize for lack of sample data as I work with sensitive data but syntax or examples for what I want to create would be greatly appreciated.

[Shivu-2000 · Accepted solution]

Hi   

You can create two separate measures that filter the Compliance % measure for 2023 and 2024 using the CALCULATE function in DAX. Assuming your date table is named 'Date' and the year column is 'Year', the syntax would be:

Compliance 2023 % = 
CALCULATE( 
    [Compliance %], 
    'Date'[Year] = 2023 
)

Compliance 2024 % = 
CALCULATE( 
    [Compliance %], 
    'Date'[Year] = 2024 
)

Let me know if you need further refinements! 🚀

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Happy to help!

[equevedo84]

Success! Thank you very much, I was overthinking the measure syntax turns out.