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, Hoping someone can help me with a formula for PowerBI which I would usually use countif for in excel.
I have a column containing results as either "yes" or "no". I need to calculate a new measure - the percentage of "no" values.
In excel I would use a count of "no", divided by the count of all values:
=COUNTIF(C1:C1006,"No")/COUNTA(C2:C1006)
How would I write a similar formula in Power BI? What are the equivalent functions?
Thank you!
Solved! Go to Solution.
Hi @gempar
Something like this should be close. Just upcate the Table and ColumnName to your own column and give it a whirl
Measure = DIVIDE( COUNTROWS(FILTER('Table','Table'[ColumnName]="No")), COUNTROWS('Table') )
Hi @gempar
Something like this should be close. Just upcate the Table and ColumnName to your own column and give it a whirl
Measure = DIVIDE( COUNTROWS(FILTER('Table','Table'[ColumnName]="No")), COUNTROWS('Table') )
Hey @Phil_Seamark,
I've tried this measure & it doesn't seem to work when the pivot table rows are from a different table. Every row shows the same total. It does work when aggregating using fields from the same table as the Driving Local YN column (Trips).
- The Expense Customer PRO ID field in the pivot table image is from a different table called 'Trip Expenses'.
- The Driving Local YN column has the values Y, N or blank, so I used COUNTA for the denominator so it won't count blank values and skew the numbers.
- The tables are linked together in the model by a Trip ID column.
I've tried everything on the internet and can't get it to work. Any help would be immensely appreciated.
Let me know if you need any more information to help & thank you for your time.
Thank you very 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 |
---|---|
107 | |
97 | |
75 | |
65 | |
53 |
User | Count |
---|---|
144 | |
103 | |
98 | |
85 | |
64 |