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'm new to Power BI and still trying to navigate my way around the app.
I want to create a Dashboard to show the status of testing, i only have text and date in my table and when i drag the column to the report, all i see is data. I know i need to create a measure which will get me started to virtualize my data.
Columns headers in my table - Defects No, App Name, App Description, Date, Status
First of all, i need to know how to get the total Number of defects? I have used the Sum function for "defects No" column but the number is wrong as this is just a number for each defects logged.
How do i go about doing this? I appreciate the help. Thanks
Solved! Go to Solution.
Hi @omooba ,
Try COUNTROWS(YourTableName). May I also suggest you get the book, Supercharge Power BI by @MattAllington or something similar to get you started?
Let me know if you have any questions.
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel
Proud to be a Super User!
Hi @omooba ,
Here is an a blog about dealing with blanks that you might enjoy.blank in dax There is also count, counta, countax.
The COUNTX function takes two arguments. The first argument must always be a table, or any expression that returns a table. The second argument is the column or expression that is searched by COUNTX.
The COUNTX function counts only values, dates, or strings. If the function finds no rows to count, it returns a blank.
If you want to count logical values, use the COUNTAX function.
Nathaniel
Proud to be a Super User!
Hi @omooba ,
Try COUNTROWS(YourTableName). May I also suggest you get the book, Supercharge Power BI by @MattAllington or something similar to get you started?
Let me know if you have any questions.
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel
Proud to be a Super User!
Thanks for your help, that did work but its worth pointing out that it will also count "null" rows.
But it worked. appreciate.
Hi @omooba ,
Here is an a blog about dealing with blanks that you might enjoy.blank in dax There is also count, counta, countax.
The COUNTX function takes two arguments. The first argument must always be a table, or any expression that returns a table. The second argument is the column or expression that is searched by COUNTX.
The COUNTX function counts only values, dates, or strings. If the function finds no rows to count, it returns a blank.
If you want to count logical values, use the COUNTAX function.
Nathaniel
Proud to be a Super User!
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 |
---|---|
48 | |
24 | |
20 | |
14 | |
12 |
User | Count |
---|---|
55 | |
48 | |
43 | |
19 | |
18 |