Forum Discussion

davehardikkumar's avatar
davehardikkumar
Icon for Helper I rankHelper I
3 years ago
Solved

distinct total

Hello Friends I need help with distinct total.     Below is table column1         Column2 A                      10 B                       20 A                       10 C                    ...
  • tamerj1's avatar
    tamerj1
    3 years ago

    davehardikkumar 
    Place Column1 in a table visual along with the following measure

    Column2Measure =
VAR T =
    SUMMARIZE ( 'Table', 'Table'[Column1], 'Table'[Column2] )
RETURN
    IF (
        HASONEVALUE ( 'Table'[Column1] ),
        SUMX ( T, 'Table'[Column2] ),
        SUMX (
            T,
            IF ( COUNTROWS ( CALCULATETABLE ( 'Table' ) ) >= 2, 'Table'[Column2] )
        )
    )
tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
3 years ago

Hi davehardikkumar 
Is this a data table or a table visual? Also please clarify further the desired output and present the complete picture.

davehardikkumar's avatar
davehardikkumar
Icon for Helper I rankHelper I
3 years ago

its a table

and output should be

 

 Column1               Coulmn2

      A                          10

      B                          20

      C                          30

                                ------

                            Total= 10