Count the number of times an item appears in 2 columns

[Anonymous]

Hello everyone,

I want to make a ring graph from this table:

This situation represents the case where there are visits to a site by 2 people each time, a visitor and a co-visitor.

I would like to make a ring graph which displays the number of occurrences of each first name.

For example, Albin should be worth 3 on my graph (1 visitor and 2 co-visitors).

But every time I try to do this I can't find the method for a long time.

If anyone has a solution or any ideas, I'd love to hear from you 🙂

Thanks everyone!

[Anonymous]

Thanks a lot guys ! database is not my thing ahha

[Ahmedx]

Based on your description, I created data to reproduce your scenario. The pbix file is attached in the end.

Count the number of times.pbix

[barritown]

Hi @Anonymous,

I'd solve your task with an additional table (Modeling -> New Table) like this:

In plain text:

people = 
ADDCOLUMNS (
    DISTINCT ( 
        UNION ( 
            SELECTCOLUMNS ( data, "person", [visiteur] ), 
            SELECTCOLUMNS ( data, "person", [co visiteur] ) ) ),
    "count", 
    COUNTROWS ( FILTER ( data, [visiteur] = [person] ) ) + COUNTROWS ( FILTER ( data, [co visiteur] = [person] ) ) )

Best Regards,

Alexander

My YouTube vlog in English

My YouTube vlog in Russian