cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
omooba
Regular Visitor

DAX help on text only table

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

2 ACCEPTED SOLUTIONS

Accepted Solutions
Super User IV
Super User IV

Re: DAX help on text only table

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





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




View solution in original post

Super User IV
Super User IV

Re: DAX help on text only table

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





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




View solution in original post

3 REPLIES 3
Super User IV
Super User IV

Re: DAX help on text only table

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





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




View solution in original post

Highlighted
omooba
Regular Visitor

Re: DAX help on text only table

Thanks for your help, that did work but its worth pointing out that it will also count "null" rows. 

But it worked. appreciate. 

Super User IV
Super User IV

Re: DAX help on text only table

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





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




View solution in original post

Helpful resources

Announcements
New Ranks Launched March 24th!

New Ranks Launched March 24th!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power BI Community!

‘Better Together’ Contest Finalists Announced!

‘Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

Arun 'Triple A' Event Video, Q&A, and Slides

Arun 'Triple A' Event Video, Q&A, and Slides

Missed the Arun 'Triple A' event or want to revisit it? We've got you covered! Check out the video, Q&A, and slides now.

Join THE global Microsoft Power Platform event series.

Join THE global Power Platform event series.

Attend for two days of expert-led learning and innovation on topics like AI and Analytics, powered by Dynamic Communities.

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors