Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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.
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
115 | |
112 | |
105 | |
95 | |
58 |
User | Count |
---|---|
174 | |
147 | |
136 | |
102 | |
82 |