Forum Discussion
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...
amitchandak
Super User
Super Userzabman , 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)
)
)
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