The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.
Hi,
I am rying to calculate the number of times 3 different strings appear in a column.
This measure works for one value -> CountPunctuality = CALCULATE(COUNTROWS(OTIF),OTIF[Punctuality] = "On Time")
I need to also count the number of times 2 other strings appear in the same column. Tried using or , & but nothing's working.
Solved! Go to Solution.
@android1 You can either create Measures for EACH one - the same as before
Just change "On Time" - so you'll have 3 Measures
Or do as in the picture...
Create a Table => drag the column twice to the Values area => the second column change to Count
This is faster but you'll have more flexibility later on if you create the individual Measures
@android1 Try this...
CountPunctuality = COUNTROWS ( FILTER ( OTIF, OTIF[Punctuality] = "On Time" ) )
Hi Sean,
How do I add 2 more text values to this. I want to count the number of times 'On Time', 'Late', 'Early'
appears in the column.
Thanks
@android1 You can either create Measures for EACH one - the same as before
Just change "On Time" - so you'll have 3 Measures
Or do as in the picture...
Create a Table => drag the column twice to the Values area => the second column change to Count
This is faster but you'll have more flexibility later on if you create the individual Measures
That's great. Thanks for your help Sean.
User | Count |
---|---|
68 | |
63 | |
59 | |
54 | |
28 |
User | Count |
---|---|
182 | |
81 | |
63 | |
47 | |
41 |