Forum Discussion

GKJARC's avatar
GKJARC
Icon for Resolver I rankResolver I
3 years ago

Comparing values to target values

Hi everyone,   I'm trying to compare achieved lead times to target lead times. These target values come from a database and can differ per year. My sample PBIX-file can be downloaded via the link ...
Need Help
GKJARC's avatar
GKJARC
Icon for Resolver I rankResolver I
3 years ago

Thank you for your suggestion. I now added a link to the sample file at the bottom of my initial post.

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
3 years ago

Here is the measure used as a visual filter

 

I also modified the data model a bit.  Targets are not really a dimension table, at least how I understand your business premise.

 

 

  • GKJARC's avatar
    GKJARC
    Icon for Resolver I rankResolver I
    3 years ago

    Thanks lbendlin for looking into it.  I understand that the measure Target achieved can be added in the side bar filters, but for users I'd prefer to add it in a slicer if possible. Although this is a nice-to-have.

     

    The more important question is how to find the right target.
    The target for %MaintenanceKey 840 is 4 instead of 5 (because start date year = 2023). What would be a measure to find the target where the target year equals the start date year?