Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Target store measure

Hi,

 

I want to show the target rate of sales made by the staff and the store. I want to create a measure. can you help me.

 

target person
target store
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi Anonymous 

     

    Hi Anonymous

    First, to implement the state of your line chart, you need a date column. Secondly, what does the line of store in your picture represent ? I create a sample , you can refer to .

    Best Regards,
    Community Support Team _ Ailsa Tao
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi Anonymous 

     

    Hi Anonymous

    First, to implement the state of your line chart, you need a date column. Secondly, what does the line of store in your picture represent ? I create a sample , you can refer to .

    Best Regards,
    Community Support Team _ Ailsa Tao
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • PurpleGate's avatar
    PurpleGate
    Resolver III
    4 years ago

    Are you wanting to just divide [persontarget] with [storeTarget] to get a percentage?

    DIVIDE(SELECTEDVALUE('Hedefler'[person Target]),SELECTEDVALUE('Hedefler'[Store target]))

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Thank you for your answer.

    I'm sorry I couldn't express what I wanted to do.
    I want to show the sales of the store and staff in a graph according to their quotas