topic Targetline on combochart in DAX Commands and Tips

Targetline on combochart

zabman — Mon, 27 Jun 2022 01:27:33 GMT

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

Re: Targetline on combochart

amitchandak — Mon, 27 Jun 2022 03:15:09 GMT

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)
)
)

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)
)
)

Re: Targetline on combochart

zabman — Mon, 27 Jun 2022 03:30:38 GMT

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