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.
Hi All,
I've spent far too many hours today trying to figure out what is probably a simple thing for you all...
I have a column in PBI that has either 0 or 1 in it for 200+ rows. I want to count the "1"'s. I've tried allsorts and been through all of the questions and answers here but they are far more complicated than this.
The column with the 0 and 1 in is "Start 28d" - please help? This would be simple in Excel: countif(range > 0) or something.
Thanks,
Martin
Solved! Go to Solution.
@Anonymous
if the column only has two values,0 and 1, what about use SUM ? The result of SUM is the result of counting 1.
Proud to be a Super User!
@Anonymous
if the column only has two values,0 and 1, what about use SUM ? The result of SUM is the result of counting 1.
Proud to be a Super User!
Thanks for this - I should have gotten it, but my mind was set on 'count'. All working as it should - thank you 🙂
you are welcome
Proud to be a Super User!
Hi,
try
Thanks! This worked for one of them (start dates) but gives me an error when trying to replicate for finish dates?
Finish 28d = IF(Task[Finish Next Period] > -28 && Task[Finish Next Period] < 0, 1, 0)
Finish 28d Qty = CALCULATE ( count (Task[Finish 28d] ),Task[Finish 28d] = 1 )
Start 28d = IF(Task[Start Next Period] > -28 && Task[Start Next Period] < 0, 1, 0)
Start 28d qty = CALCULATE ( COUNT ( Task[Start 28d] ), Task[Start 28d] = 1 )
Hi,
i don't think it's a problem of the measure.
Task[Finish Next Period] or Task[Start Next Period] are calculated columns?
Yes they are calculated.
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 |
---|---|
117 | |
107 | |
70 | |
70 | |
43 |
User | Count |
---|---|
148 | |
106 | |
104 | |
89 | |
65 |