Forum Discussion
Unable to perform Count
I created a new table using Union and Summarize: Summary Table = Union( Summarize( 'Table 1', 'Table 1' [ID], 'Table 1' [Type]), Summarize ('Table 2', 'Table 2' [ID], 'Table 2' [Type])) When I inse...
You summarize which returns the distinct combo of id and type per table. You then union them. You would only expect the distinct count and count to differ if you have id and type combo common between table 1 and 2. Is this the case?
You summarize which returns the distinct combo of id and type per table. You then union them. You would only expect the distinct count and count to differ if you have id and type combo common between table 1 and 2. Is this the case?
Thank Deku. You remind me where is the problem. When I create new table using summarize, I select only 'same column' and remove 'dif. column', which PBI turn only 01 row rather than various rows. I should add more column to the new table. Thank you.