Forum Discussion

PBI_37's avatar
PBI_37
Icon for Helper I rankHelper I
1 year ago
Solved

Data modeling - Actual vs Target

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 : ...
Need Help
  • Tutu_in_YYC's avatar
    Tutu_in_YYC
    1 year ago

    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]

  • Anonymous's avatar
    Anonymous
    1 year ago

    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.

Tutu_in_YYC's avatar
Tutu_in_YYC
Icon for Super User rankSuper User
1 year ago

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]