Forum Discussion

pal95's avatar
pal95
Icon for Helper III rankHelper III
1 year ago
Solved

DAX Measure to count only rows with specific text

Hi, I have a table that should show the total number of SOP documents read by a user. I am creating a table like this for that:   Below is the table I take values from:   In the co...
Need Help
  • ThomasWeppler's avatar
    ThomasWeppler
    1 year ago

    Hi pal95 

    I think this should do the trick.

    MEASURE =
    CALCULATE ( COUNT ( Table1[SOP 2] ), Table2[Document Type] = "SOP" )

    I hope this solved your problem 🙂

  • ThomasWeppler's avatar
    ThomasWeppler
    1 year ago

    Fair enough that will just make it easier if all the data is in one table.
    I will write table as a placeholder for your tables name where the data is.
    MEASURE =
    CALCULATE ( COUNT ( Table[User Name] ), Table[Document Type] = "SOP" )

ThomasWeppler's avatar
ThomasWeppler
Icon for Impactful Individual rankImpactful Individual
1 year ago

Hi pal95 

I think this should do the trick.

MEASURE =
CALCULATE ( COUNT ( Table1[SOP 2] ), Table2[Document Type] = "SOP" )

I hope this solved your problem 🙂

  • pal95's avatar
    pal95
    Icon for Helper III rankHelper III
    1 year ago

    No, sorry, table 1 isn't real - it is just something that I created through PowerBI, so I cannot reference it. It should all be through the table 2

    • ThomasWeppler's avatar
      ThomasWeppler
      Icon for Impactful Individual rankImpactful Individual
      1 year ago

      Fair enough that will just make it easier if all the data is in one table.
      I will write table as a placeholder for your tables name where the data is.
      MEASURE =
      CALCULATE ( COUNT ( Table[User Name] ), Table[Document Type] = "SOP" )