Count number of values in axis and show it on tooltip

[qmestu]

Hi,

I have the following sample of values:

BRAND	YEAR	VALUE
A	2021	20
A	2022	10
A	2020	5
A	2019	8

In a visual for a line chart where X is the year how can i have a tooltip that counts the total of years that the line represents? For each datapoint the tooltip should read the year, the value and the number of years (4).

Thanks.

[johnt75 · Accepted solution]

You could create a measure like

Num Years = COUNTROWS( ALLSELECTED( 'Table'[Year] ) )

and add that to the tooltip.