Running Count of Distinct Values at UI Level

[s4ni9r]

Dear All,

Could you please help me with the requirement

i have got the below table

Month	Value
Jan	A
Jan	B
Jan	C
Jan	D
Feb	A
Feb	B
Feb	C
Mar	A
Mar	B
Mar	C
Mar	D
Mar	E

Expected Result :

if the User Selects, JAN - The distinct count of values in Jan- 4 

if the User Selects, JAN +FEB - The distinct count of values in JAN+FEB -  4 

if the User Selects, JAN +FEB+MARCH - The distinct count of values in JAN+FEB+MARCH - 5(A,B,C,D,E)

expected result
jan	4
Feb	4
Mar	5

Thanks in Advance

[Joseph_Musekura]

Hi @s4ni9r ,

Did you try to use Count({$} distinct Value) as measure?

Regards,

[s4ni9r]

No, it doesnt work