How can I count only different row?

[saranp780]

I have a lot of data on computer hardware. So my requirement is I would like to compare the data that I exported text from the script. and the data are automatically running.   The data that I have now should be like this.

Name	Surname	CPU	RAM	Monitor	GPU
Joshua	Salos	Intel Core i7-8700	15.99 GB	Samsung 21.5"	Intel UHD 620
Klaus	Mikaelson	AMD Ryzen3 3200G	32.00GB	MSI 27"	AMD Radeon X570
Tom	YSS	AMD Ryzen5 3600	16.00GB	MSI 24.8"	Nvidia Geforce 1660 TI
Stefen	Salvatore	Intel Core i7-9750H	16.00GB	Lenovo 21.5"	Nvidia Geforce 2070
Joshua	Salos	Intel Core i7-8700	32.00 GB	Samsung 21.5"	Intel UHD 620
Klaus	Mikaelson	AMD Ryzen3 3200G	32.00GB	MSI 27"	AMD Radeon X570
Tom	YSS	AMD Ryzen9 3900X	16.00GB	MSI 24.8"	Nvidia Geforce 1660 TI
Stefen	Salvatore	Intel Core i7-9750H	16.00GB	Lenovo 21.5"	Nvidia Geforce 2070

How can I count only different Hardware row and only show with DAX like below? 



Count: 2 Different rows.

Joshua	Salos	Intel Core i7-8700	15.99 GB	Samsung 21.5"	Intel UHD 620
Joshua	Salos	Intel Core i7-8700	32.00 GB	Samsung 21.5"	Intel UHD 620
Tom	YSS	AMD Ryzen5 3600	16.00GB	MSI 24.8"	Nvidia Geforce 1660 TI
Tom	YSS	AMD Ryzen9 3900X	16.00GB	MSI 24.8"	Nvidia Geforce 1660 TI

Just Count only different rows. Don't count the same rows. In my example data, the row different are 2.  And when I click on 2 it can be shown the text.

Thank you every reply.

[v-yingjl · Accepted solution]

Hi @saranp780 ,

First you should know that the interactions between card visual and other visuals are single diretion, the card visual only shows the aggregated value so that when we click on it it will not interact with any visual.

In this case, to achieve your requirements, you can try to create these measures:

Create one measure to show ‘2’ result in the card visual:

Count = 
VAR tab =
    SUMMARIZE (
        FILTER (
            ALL ( 'Table' ),
            COUNTX (
                FILTER (
                    ALL ( 'Table' ),
                    'Table'[Name] = EARLIER ( 'Table'[Name] )
                        && 'Table'[CPU] = EARLIER ( 'Table'[CPU] )
                        && 'Table'[RAM] = EARLIER ( 'Table'[RAM] )
                        && 'Table'[Monitor] = EARLIER ( 'Table'[Monitor] )
                        && 'Table'[GPU] = EARLIER ( 'Table'[GPU] )
                ),
                [Name]
            ) = 1
        ),
        [Name]
    )
RETURN
    COUNTX ( FILTER ( tab, [Name] IN DISTINCT ( 'Table'[Name] ) ), [Name] )

Create another measure to filter the table visual, set its value as 1 and put it in the visual filter:

visual control =
IF ( NOT ( ISBLANK ( [Count] ) ), 1, 0 )

Attached a sample file in the below, hopes to help you.

Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

I suggest to put the appropriate columns together and use for instance DISTINCTCOUNT(). The question is what you really want to achieve?

[amitchandak]

@saranp780 , Logic of split is not clear. Can you explain

You can try to unpivot in power query

https://radacad.com/pivot-and-unpivot-with-power-bi
Transpose : https://yodalearning.com/tutorials/power-query-helps-transposing-data/