Targetline on combochart

[zabman]

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

[amitchandak]

@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]

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