Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I have a column of text that I need to count specific text. Here is a small sample:
Classification
Injury
Environmental;Near Miss
Injury;Environmental
Near Miss; Injury
Near Miss
Equipment Damage
I need help with a formula that will count Near Miss from the Classification Column. In the data sample above, I'd expect Near Miss to count 3 times.
I'm sure this is simple, but for some reason I can't get it!
Solved! Go to Solution.
Hi @BeckyPeppin
Is this along the lines of what you need?
It's a calculated measure
My Count = CALCULATE( COUNTROWS('Table3'), SEARCH( "Near Miss",'Table3'[Classification],,0) )
Hi @BeckyPeppin
Is this along the lines of what you need?
It's a calculated measure
My Count = CALCULATE( COUNTROWS('Table3'), SEARCH( "Near Miss",'Table3'[Classification],,0) )
I am doing something similar and have 2 options
Asthma Prev = CALCULATE(COUNT(Epi[asthma active]),Epi[asthma active] = "true")/COUNT(Epi[ID])
or
Asthma Prev = CALCULATE(COUNTROWS(Epi),Epi[asthma active] = "true")/COUNT(Epi[ID])
Both give the same answer. Could you tell me the differences in the 2 apparoaches and which one to go for.
Also Asthma Prev = CALCULATE(COUNTA(Epi[asthma active]),Epi[asthma active] = "true")/COUNT(Epi[ID]) is alsoe giving me the same answr. ALL 3 OPTIONS SEEMS TO WORK. Butnot sure which one is BEST
Thank you so much!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |