Forum Discussion

zabman's avatar
zabman
Frequent Visitor
4 years ago

Targetline on combochart

Hi,
I would like to have a target line on a combo chart that shows the percentage from January. I have created a DAX measure as follows:

target_line =
DIVIDE (
CALCULATE (
COUNT ( Data[File No] ),
FILTER( Data, Data[Compliant] = "Yes"),
FILTER( datetable, datetable[FYMM] = 2201)
),
CALCULATE ( COUNT ( Data[Compliant] ),
FILTER( datetable, datetable[FYMM] = 2201)
)
)
 
The result is correct, but when used as a line value, it only displays on the Jan-22 column rather than accross the entire year
measure
target

2 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    4 years ago

    zabman , Try like

     

    target_line =
    DIVIDE (
    CALCULATE (
    COUNT ( Data[File No] ),
    FILTER( Data, Data[Compliant] = "Yes"),
    FILTER( all(datetable), datetable[FYMM] = 2201)
    ),
    CALCULATE ( COUNT ( Data[Compliant] ),
    FILTER( all(datetable), datetable[FYMM] = 2201)
    )
    )

    or

    target_line =
    DIVIDE (
    CALCULATE (
    COUNT ( Data[File No] ),
    FILTER( Data, Data[Compliant] = "Yes"),
    FILTER( all(datetable[FYMM]), datetable[FYMM] = 2201)
    ),
    CALCULATE ( COUNT ( Data[Compliant] ),
    FILTER( all(datetable[FYMM]), datetable[FYMM] = 2201)
    )
    )

    • zabman's avatar
      zabman
      Frequent Visitor
      4 years ago

      Hi,

      I get the same result as before. The percentage is correct, but instead of showing on every month the January percentage, it only shows on January