Display total no of customers in totals and customer names in column of table visual

[prajwal1]

Hey guys, I need to display the customer names as a column in table visual and count of cutomers in the Totals of the same column just like below. Please help me with some ideas. Thanks in advance.

Row	CustNames
1	A
2	B
3	C
4	D
Total	4

[tamerj1 · Accepted solution]

Hi @prajwal1 
You can try

CustNames =
IF (
    ISINSCOPE ( 'Table'[Customer Name] ),
    SELECTEDVALUE ( 'Table'[Customer Name] ),
    DISTINCTCOUNT ( 'Table'[Customer Name] )
)

[tamerj1 · Accepted solution]

Hi @prajwal1 
Please refer to attached sample file withthe proposed solution

CustNames = 
IF (
    HASONEVALUE ( 'Index'[Row Number] ),
    MAXX ( 
        FILTER ( 
            ADDCOLUMNS ( 
                VALUES ( 'Table'[Customer Name] ),
                "@Rank", RANKX ( ALLSELECTED ( 'Table'[Customer Name] ), 'Table'[Customer Name],, ASC )
            ),
            [@Rank] = VALUES ( 'Index'[Row Number] )
        ),
        'Table'[Customer Name]
    ),
    DISTINCTCOUNT ( 'Table'[Customer Name] )
)

[poojadc_i]

Hello @tamerj1  ,

Your solution is just perpect but I have another level of difficulty would be great if you can suggest. 



In the table I have measure value as well which is giving wrong value with CustName column. 
Can you help !!

[tamerj1]

Hi @poojadc_i 
You can do the following:

[tamerj1 · Accepted solution]

Hi @prajwal1 
You can try

CustNames =
IF (
    ISINSCOPE ( 'Table'[Customer Name] ),
    SELECTEDVALUE ( 'Table'[Customer Name] ),
    DISTINCTCOUNT ( 'Table'[Customer Name] )
)

[prajwal1]

This is working when the original column is there in the table. How can I do this without using that column in the table.?

[tamerj1]

@prajwal1 
Which column are you going to use in the table? Or you you want to see the result on a card visual? Please clarify 

[prajwal1]

Not in a Card. I want to display in a table visual like I mentioned in my question.

I want to display Customer names in a column and the total number of customers in 'Totals' in table visual without using the original column in the table.

The above Dax expression working when the original column is also available in the table visual. I don't want to use that column. I will use the measure only

[tamerj1]

@prajwal1 

I understand, but there must be some column placed there in the table. Such solutions cannot be straightforward as it should provide a workaround over this property of power bi table. I'll be back to office shortly. Let me see what can I do.