Count measures that contains "A"

[Anonymous]

I have a following visual.

customers	measure 1	measure 2	measure 3	count "A" measure
01	A	B	C	1
02	A	A	B	2
03	C	B	C	0
04	A	C	A	2
05	A	A	A	3

how to create a measure to count the number of "A" in measure 1, 2 and 3.

Kind regards

[PaulDBrown · Accepted solution]

Try

Count A =
VAR M1 = IF([Measure 1] = "A", 1)
VAR M2 = IF([Measure 2] = "A", 1)
VAR M3 = IF([Measure 3] = "A", 1)
RETURN
M1 + M2 + M3

[Anonymous]

perfect thank you!!

[Tutu_in_YYC]

What are the DAX measures for measure 1, 2 and 3?

[Anonymous]

They are IF measures to group customers based on some condistions, for example meaure 1 is 

ordered days Group = IF([ordered days Running Total]/[count days total] < 0.7, "A",IF([ordered days Running Total]/[count days total] >= 0.7 && [ordered days Running Total]/[count days total] < 0.9, "B", "C"))

and the other two measures are the same just different conditions.

[Samarth_18]

HI @Anonymous ,

Please try this:-

Measure  = COUNTROWS(FILTER('Table (6)',CONTAINSSTRING([Measure 1], "A") || CONTAINSSTRING([Measure 2], "A") || CONTAINSSTRING([Measure 3], "A")))

Thanks,

Samarth