Forum Discussion

jclorenzo's avatar
jclorenzo
Frequent Visitor
5 years ago
Solved

COUNTA Result While displaying original data.

We would like to display the total count in a table grid of the COUNTA (Counts the number of records that are not empty) result.  But maintain the original text.   Similar to the following screensh...
Need Help
  • ChrisMendoza's avatar
    ChrisMendoza
    5 years ago

    jclorenzo -

    ConcatX =
VAR __temp =
    CALCULATETABLE ( 'Table (2)', 'Table (2)'[Column2] <> BLANK () )
RETURN
    IF (
        HASONEVALUE ( 'Table (2)'[Column1] ),
        CONCATENATEX ( 'Table (2)', 'Table (2)'[Column2], " | " ),
        COUNTROWS ( __temp )
    )

ChrisMendoza's avatar
ChrisMendoza
Icon for Resident Rockstar rankResident Rockstar
5 years ago

jclorenzo -

 

Measure = 
VAR __temp = 
CALCULATETABLE(
    'Table',
    'Table'[Priority] <> BLANK()
)

RETURN
    COUNTROWS(__temp)

 

jclorenzo's avatar
jclorenzo
Frequent Visitor
5 years ago

Hi Chris,  thank you for your suggestion, but we need the count value at the bottom of the DONE column.  Identical to how Excel displays it.  Any suggestions ?

  • ChrisMendoza's avatar
    ChrisMendoza
    Icon for Resident Rockstar rankResident Rockstar
    5 years ago

    jclorenzo -

    ConcatX =
VAR __temp =
    CALCULATETABLE ( 'Table (2)', 'Table (2)'[Column2] <> BLANK () )
RETURN
    IF (
        HASONEVALUE ( 'Table (2)'[Column1] ),
        CONCATENATEX ( 'Table (2)', 'Table (2)'[Column2], " | " ),
        COUNTROWS ( __temp )
    )

    • jclorenzo's avatar
      jclorenzo
      Frequent Visitor
      5 years ago

      Excellent; It worked perfectly.  Thanks !!!