Forum Discussion

equevedo84's avatar
equevedo84
Frequent Visitor
1 year ago
Solved

Create New Measure that Filters Current Measure to a Specific Year

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 c...
Need Help
Tips and Tricks
  • Shivu-2000's avatar
    Shivu-2000
    1 year ago

    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!

Shivu-2000's avatar
Shivu-2000
Responsive Resident
1 year ago

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's avatar
equevedo84
Frequent Visitor
1 year ago

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