topic Gap between actual and target in matrix table in DAX Commands and Tips

Gap between actual and target in matrix table

yh1978 — Thu, 06 Jun 2024 13:02:31 GMT

Hello everyone
I am trying to build a matrix report based on 3 tables
which calculates the actual compared to the target.
It totally messed me up.
I would appreciate it if someone could help me with this.
Thank you

Re: Gap between actual and target in matrix table

bhanu_gautam — Thu, 06 Jun 2024 13:40:39 GMT

What is the exact requirement and where are you stuck can you elaborate

Re: Gap between actual and target in matrix table

yh1978 — Sun, 09 Jun 2024 11:34:52 GMT

Hey
Let's start with the first problem
When I bring the data of targets to the matrix table, duplicates are created. I want each client to have one line with the actual sales against the targets.
Thank you

Re: Gap between actual and target in matrix table

Anonymous — Tue, 11 Jun 2024 03:04:41 GMT

Hi yh1978

Try the following:

Create tables relationship.

Create a visual.

Here is the result.

Regards,

Nono Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Re: Gap between actual and target in matrix table

yh1978 — Mon, 17 Jun 2024 12:19:31 GMT

Hey
thank you very much for your answer.
I did everything according to your recommendation.
Everything is going fine until I add meazure which calculates the gap between the actual sales and the target sales.