Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |