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 )
    )

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 !!!