How to present 2 text columns collectively on one graph

[drahmedsalem]

I have primary and secondary data in 2 columns. I need to present them on one axis and to be collected (summed) automatically once presented on the graph. for example, I have 10 TT, I need to be automatically counted to be 12 (i.e. to reflect the total numbers) as well as 

 

Business  Model	2ndry Business  Model
TT	-
TT	-
XYZ	-
TT	TT
XYZ	-
XYZ	-
Commercialization	-
Commercialization	-
XYZ	-
XYZ	-
XYZ	-
XYZ	-
XYZ	-
XYZ	-
XYZ	-
TT	Commercialization
TT	Commercialization
TT	Commercialization
TT	-
TT	-
Commercialization	-
TT	-
TT	-
Commercialization	-
Commercialization	XYZ
Commercialization	-
Commercialization	-
XYZ	TT

[v-janeyg-msft · Accepted solution]

Hi, @drahmedsalem 

In addition to the methods mentioned above, you can also clean the data directly in PQ, so that the report will be made faster.

You can get two single lists through 'reference', then unify the names for append operation.

If you still have problems, please feel free to ask me.

Best Regards

Janey Guo

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@drahmedsalem ,

create new table.
Business = distinct(union(distinct(Table[Business Model]), distinct(Table[2ndry Business Model])))

Join these two columns with new table. One join will active assume (Business Model one), and one will be inactive

then try measure like this with Business Model from Business Model

count(Table[Business Model]) + calculate(count(Table[2ndry Business Model]), userelationship(Table[2ndry Business Model] , Business[Business Model]))

https://radacad.com/userelationship-or-role-playing-dimension-dealing-with-inactive-relationships-in...

[drahmedsalem]

Thanks @amitchandak for your reply.

Regarding the second equation,

1. shall I start as "new measure or column"? 
2. Table (is the old or new one)?
3. Business Model (in old or new table)?

Thanks.