Forum Discussion

Niunias's avatar
Niunias
Frequent Visitor
5 years ago
Solved

Dynamic target in measures

Hello All,   I need a help with a dynamic target and according to this target I would like to calcualte a measure. Let me give you some example.   I have a list of countries and each of them have...
  • Jihwan_Kim's avatar
    Jihwan_Kim
    5 years ago

    Hi, Niunias 

    I am not sure how your data model and tables look like.

    I assume you can create a target table like below.

    Please check the below picture and the sample pbix file's link down below, whether it is what you are looking for.

     

     

    Tickets within Target =
     
    CALCULATE (
    COUNTROWS ( Tickets ),
    FILTER ( Tickets, Tickets[Days] <= SELECTEDVALUE ( Targets[Target] ) )
    )
     
     
     

    Hi, My name is Jihwan Kim.


    If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.


    Linkedin: https://www.linkedin.com/in/jihwankim1975/

Niunias's avatar
Niunias
Frequent Visitor
5 years ago

Brilliant ! Thanks a lot 🙂 You have saved my weekend 🙂