Data modeling - Actual vs Target

[PBI_37]

Hi everyone,

I would like to compare Actual vs Target.

I have a problem with my Data Model.

Actual table :

Target table (the target is fixed for the year) :

Data model :

It does not work :

Desired outpout :

Here the link of PBI file :

https://drive.google.com/file/d/1WLSOCFoAXzECpaJK7VSTCKw_WLvsy2_J/view?usp=sharing

Thank you for your help

[Tutu_in_YYC · Accepted solution]

Try this:

For Actual Value replace with this measure: ActValue = SUM(Actual[Actual Value])
For target, use this: Target = IF( [ActValue] = BLANK(), BLANK(), MAX(Target[Target Value]))

Variance : Variance = [ActValue] - [Target]

[PBI_37]

Thank you v-tianyich-msft and Tutu_in_YYC

[Anonymous · Accepted solution]

Hi @PBI_37 ,

I have made changes in your source file, please check the result below:

An attachment for your reference. Hope it helps!

Best regards,
Community Support Team_ Scott Chang

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

[OktayPamuk80]

Hi,

Did you try to connect your calendar.year with your target.year? In your visual, you should then use calendar.date, too.

Regards,
Oktay

Did I answer your question? Then please mark my post as the solution.

If I helped you, click on the Thumbs Up to give Kudos.

[Tutu_in_YYC · Accepted solution]

Try this:

For Actual Value replace with this measure: ActValue = SUM(Actual[Actual Value])
For target, use this: Target = IF( [ActValue] = BLANK(), BLANK(), MAX(Target[Target Value]))

Variance : Variance = [ActValue] - [Target]