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 -

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