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 insert visual from this new summary table, PBI return distinct count of ID by Type. When I switch to Count, it still display value of distinct count.
Does anyone know how to fix?
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?
2 Replies
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?