Need count across multiple columns with the same data peppered in a table

[Anonymous]

I have 3 columns (A1, A2, A3) each containing the same data peppered throughout the 3 columns. I also have 1 column (TAG No) that all 3 columns relate to. I am new to PowerBI and I am trying to be able to display a count of data that is the same across the 3 columns (A1, A2, A3).

I also have several slicers that drill down the entire data set such as all tags that are issued (Issued = I%) and are smaller than 2". From my filter, the display set shows the available data based on the filter. What I would like to be able to do is count all the GUA items that are contained in the 3 columns and display the result. Using GUA to quantify, my result should be GUA=5 (based on the table below). 

TAG No	A1	A2	A3
0001	AAB	GUA
0002	GUA
0003	CCB	AAB	GUA
0004	004
0005	GUA	CCB
0006	AAB	GUA

Does anyone have a suggestion as to how to go about creating this?

[jdbuchanan71 · Accepted solution]

@Anonymous 

Something like this should work for you.

GUA = 
VAR _String = "GUA"
RETURN
    CALCULATE ( 
        COUNTROWS ( YourTable ), 
        YourTable[A1] = _String || YourTable[A2] = _String || YourTable[A3] = _String
    )

[Greg_Deckler]

@Anonymous Unpivoting your columns in Power Query might be a good choice here. Otherwise, you can use MC Aggregations: Multi-Column Aggregations (MC Aggregations) - Microsoft Power BI Community