Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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]))
Solved! Go to 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
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
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 () )
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
User | Count |
---|---|
100 | |
87 | |
81 | |
76 | |
71 |
User | Count |
---|---|
113 | |
104 | |
100 | |
73 | |
65 |