Forum Discussion
Dynamic Measures with Calculation Group for Actual vs. Target KPI
Hi Lucra ,
Based on the description, may be the periods had been returned correct.
View the following document to learn more information.
Create calculation groups in Power BI (preview) - Power BI | Microsoft Learn
If the above ones can’t help you get it working, could you please provide more raw data(exclude sensitive data) with Text format to make a deep troubleshooting? It would be helpful to find out the solution.
You can refer the following links to share the required info:
How to provide sample data in the Power BI Forum
Best Regards,
Wisdom Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Good morning and thank you for your reply. I reviewed the documentation you linked and believe I have everything working. The documentation refers to using the group in a measure like this:
In this format I can use the groups without issue. When things stop working is passing in a dynamic value instead of "YOY%" like this:
Dynamic Measure Target =
VAR nextPeriod = SELECTEDVALUE('Time Intelligence Selector'[Next Period])
VAR result =
CALCULATE(
[Dynamic Measure Base],
FILTER(
ALL('Time Intelligence')
,'Time Intelligence'[Period] = nextPeriod
)
From what I've read, dynamically assigning a group item doesn't appear to be supported. I'd love for someone to tell me otherwise, though.