Cant connect my summarize table to another table (its says duplicates)

[Kristofferaabo]

Hi
I have made a SUMMARIZE table based on a large data set. Main purpose of doing this was to get a table with unique values for the 'project' which i could then connect to another table..

My problem is that I can't connect this to another project table, it tells me that 'Project'  doesn't contain unique values...

What do I do wrong? I thiough SUMMARIZE was giving uniques..?

Cheers

Kristoffer

New table = 
SUMMARIZE(
    'Old table',
    'Old Table'[Project],
    "Payments", count('Old table'[Payments]))

[v-jiascu-msft · Accepted solution]

Hi @Kristofferaabo,

There could be blank values. Please try out the following formula. But you will lose the blank values.

New table =
FILTER (
    SUMMARIZE (
        'Old table',
        'Old Table'[Project],
        "Payments", COUNT ( 'Old table'[Payments] )
    ),
    ISBLANK ( 'Old Table'[Project] ) = FALSE ()
)

Best Regards,

Dale

[Kristofferaabo]

@v-jiascu-msft you are a genious!

Vh

Kristoffer

[Kristofferaabo]

Hi @v-jiascu-msft,

This works BUT I still have a problem I didn't thought about.  I would need these Payments by country

If I pull countries in will make a *project' for each country, and I will obviously not be able to link.. can I somehow do this differently?

Can I write this and get:
Unique projects (with balnks) and get counts on payments by country?

New table =
FILTER (
    SUMMARIZE (
        'Old table',
        'Old Table'[Project],
        'Old Table'[Country],
        "Payments", COUNT ( 'Old table'[Payments] )
    ),
    ISBLANK ( 'Old Table'[Project] ) = FALSE ()
)

[v-jiascu-msft]

Hi Kristoffer,

That would depend on your data. If one country has one project, you can get the desired result. I would suggest you open a new thread in this forum and provide a sample of your data.

Best Regards,

Dale