Forum Discussion

omooba's avatar
omooba
Regular Visitor
6 years ago
Solved

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 t...
  • Nathaniel_C's avatar
    Nathaniel_C
    6 years ago

    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

  • Nathaniel_C's avatar
    Nathaniel_C
    6 years ago

    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

Nathaniel_C's avatar
Nathaniel_C
Icon for Community Champion rankCommunity Champion
6 years ago

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

omooba's avatar
omooba
Regular Visitor
6 years ago

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

But it worked. appreciate. 

  • Nathaniel_C's avatar
    Nathaniel_C
    Icon for Community Champion rankCommunity Champion
    6 years ago

    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