Create New Measure that Filters Current Measure to a Specific Year

Question

Need assistance on syntax,&nbsp; I have a measure Compliance % that exists in a Compliance Data table and has the following syntax:&nbsp;Compliance % = [Compliant Mems]/[Eligible Mems]&nbsp;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.&nbsp;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 Answer

Hi&nbsp;&nbsp;&nbsp;
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:
&nbsp;
Compliance 2023 % = 
CALCULATE( 
    [Compliance %], 
    'Date'[Year] = 2023 
)
Compliance 2024 % = 
CALCULATE( 
    [Compliance %], 
    'Date'[Year] = 2024 
)
Let me know if you need further refinements! 🚀
&nbsp;
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.Happy to help!

Forum Discussion

Create New Measure that Filters Current Measure to a Specific Year

2 Replies

Related content

Make measure ignore specific filter

How to search specific word in table filter Calculations

Dynamic measure filtering

Filter by Rank measure

Specific Filter