topic Re: Target store measure in DAX Commands and Tips

Target store measure

Anonymous — Tue, 23 Aug 2022 07:12:02 GMT

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.

Re: Target store measure

PurpleGate — Tue, 23 Aug 2022 08:02:48 GMT

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

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

Re: Target store measure

Anonymous — Tue, 23 Aug 2022 08:56:17 GMT

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

Re: Target store measure

Anonymous — Thu, 01 Sep 2022 09:41:58 GMT

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.