Forum Discussion

rshifflet's avatar
rshifflet
Frequent Visitor
7 years ago

Linear reference line from Zero to a measured Target

I am new to DAX coding and have hit a wall. I have a cumulative measure that adds revenue over time, however I am trying to add a linear reference line from 0 (zero) at the beginning of my line graph, to the target (indicated as a SUM measure), at the end of the year. I am able to get the following formula to give a strait horizontal line at zero, and I can set it at the target, but I am unable to get it to Return a line from zero to my target mesure. 

Reference =

VAR _current =

    SELECTEDVALUE ( 'FAC - Flat Data'[Revenue] )

VAR _min = 0

VAR _max =

    'FAC - Flat Data'[Total Revenue]

RETURN

    IF (

        _current = MINX (ALLSELECTED( 'FAC - Flat Data' ), [Total Revenue] ),

        0,

        _current = 'FAC - Flat Data'[Total Revenue] )

 

This is an example I found showing what I want my graph to do. 

Thanks

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable

    HI rshifflet ,

    You can write a measure to check current amount and target measure and replace value as target if summary value greater than target.

    Regards,
    Xiaoxin Sheng