visualizing two column with same contents

[Anonymous]

Hi all,

I have data set in CSV which had two columns for the source of events.  There are 8 options available for sources, and 2 can be picked and stored in CSV columns. How can I show these 8 options in power bi with % of total quantity?

id

Date

address

store_id

employee_id

cat

subcat

sub-subcat

size

source1

source

qty

type of credit

note

12573

6/11/2020

gdgdfgdf

2355

ujrth56432143r

outwear

coat

lio-35

14

loi

loi

6

fix

12573

6/11/2020

gdgdfgdf

2355

ujrth56432143r

bottom

skirt

review

10

kim

vto

16

loan

12573

6/11/2020

gdgdfgdf

2355

rhytrhtrhr

kids

school

hat

4

jet

ylp

2

credit

12573

6/11/2020

gdgdfgdf

2355

grehytr

accesory

bag

backpack

-

ylp

loi

1

high

12573

6/11/2020

gdgdfgdf

2355

ujrth56432143r

accesory

watch

smart

w

dolly

kim

1

fix

12573

6/11/2020

bdfgjjg

3358

egrhtr900

toy

doll

bella

s

smo

jet

2

loan

12573

9/11/2020

bdfgjjg

3358

dfrhrdh

outwear

raincoart

long

12

jet

ylp

4

credit

12573

9/11/2020

bdfgjjg

3358

egrhtr900

kids

skirt

belt

8

ylp

dolly

4

high

12573

9/11/2020

bdfgjjg

3358

grhrh23332

toy

xbox

3

-

loi

smo

1

fix

12573

9/11/2020

cvbffdbfgb

58744

yrttyytik89

accesory

hair dryer

200w

-

vto

jet

9

loan

12573

9/11/2020

bsfdbgff

2358

retert9885

bottom

pant

skinny

6

dolly

ylp

4

credit

12573

9/11/2020

streyhrt

4587

ryrurtj3255

top

shirt

vneck

8

come

loi

10

high

12573

9/11/2020

streyhrt

4587

ryyhrtrtj3256

top

blouse

ribbon

8

kim

vto

8

fix

12573

9/11/2020

streyhrt

4587

ryyhrtrtj3256

kids

dress

disney

6

jet

dolly

6

loan

12573

9/11/2020

reryrtrt

2358

hrthjt225588

accesory

hair tie

bow

-

ylp

come

1

credit

12573

9/11/2020

ghhtrjrtj

3687

hdfhnfg9863

top

tshirt

white

10

dolly

vto

40

high

[v-jayw-msft · Accepted solution]

Hi @Anonymous ,

Create a new table contains all source.

Table 2 = DISTINCT(UNION(SELECTCOLUMNS('Table',"source",'Table'[source]),SELECTCOLUMNS('Table',"source",'Table'[source1])))

 

Then create a measure.

Measure = CALCULATE(COUNTROWS('Table'),FILTER('Table','Table'[source]=SELECTEDVALUE('Table 2'[source])||'Table'[source1]=SELECTEDVALUE('Table 2'[source])))/COUNTROWS('Table')

Result would be shown as below.

Best Regards,

Jay

[amitchandak]

@Anonymous , Create a source dimension distinct from these two (https://www.youtube.com/watch?v=Bkf35Roman8)

Join with both sources, One join will inactive. Create a measure to activate that join and use userelationship

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

https://www.youtube.com/watch?v=e6Y-l_JtCq4