Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to 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
Proud to be a Super User!
Paul on Linkedin.
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
Proud to be a Super User!
Paul on Linkedin.
perfect thank you!!
What are the DAX measures for measure 1, 2 and 3?
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.
HI @Anonymous ,
Please try this:-
Measure = COUNTROWS(FILTER('Table (6)',CONTAINSSTRING([Measure 1], "A") || CONTAINSSTRING([Measure 2], "A") || CONTAINSSTRING([Measure 3], "A")))
Thanks,
Samarth
Best Regards,
Samarth
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
Connect on Linkedin
User | Count |
---|---|
97 | |
87 | |
76 | |
67 | |
63 |
User | Count |
---|---|
112 | |
96 | |
95 | |
67 | |
65 |