DAX count occurances in multiple column

[tamasungor]

Dear Community!

I have the next sample data set: 

date	numbers	1	2	3	4
2022.01.01	1	a	b	c	d
2022.01.01	2	b	c	d	e
2022.01.02	3	f	g	h	u
2022.01.02	4	a	s	s	d
2022.01.03	5	b	d	x	s
2022.01.03	6	v	n	f	o
2022.01.04	7	d	t	u	p
2022.01.04	8	k	u	i	ő
2022.01.05	9	t	u	p	á
2022.01.05	10	u	i	ő	ő
2022.01.06	11	h	t	u	p
2022.01.06	12	t	u	i	ő
2022.01.07	13	p	o	i	ú

if a user select a letter (for example letter "a") from the slicer, the user will get the following table (expected results):

a	2
b	1
s	2
c	1
d	2

i tried the following measure, but it seems it doesn't work properly:

count =

var filt_ = filters('unique'[unique])

var calc = DISTINCT(

        SELECTCOLUMNS(

            UNION(

                CALCULATETABLE(all(items),FILTER(items, items[1] = filt_)),

                CALCULATETABLE(all(items),FILTER(items, items[2] = filt_)),

                CALCULATETABLE(all(items),FILTER(items, items[3] = filt_)),

                CALCULATETABLE(ALL(items),FILTER(items, items[4] = filt_))),

                "id",items[numbers]))

var calc_ = CALCULATETABLE(all(items),FILTER(items, items[numbers] in calc))

return

COUNTROWS(

        UNION(SELECTCOLUMNS(items,"id",items[1]),

SELECTCOLUMNS(items,"id",items[2]),

SELECTCOLUMNS(items,"id",items[3]),

SELECTCOLUMNS(items,"id",items[4])

     ))

--------------------------------------------------------------
table relationships:
list table: tried multiple connection type, that's the last saved one, manually created table,

unique: dax created table (unique items from table items (distinct(union(items[1],items[2],items[3],items[4]))).
items: "fact table"

Currently, what i get is:

a

8

Thanks, any advice.
Tomi

[Greg_Deckler]

@tamasungor Not sure I am reading this correctly but I believe you want this: Multi-Column Aggregations (MC Aggregations) - Microsoft Power BI Community

[tamasungor]

@Greg_Deckler Thanks for the link. I checked the link, but currently i don't see, how can i apply in my case.
in the following link a sample data is available: Link 

Thank you any advice