Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
THENNA_41
Post Partisan
Post Partisan

combine value and separate value to show visual

i have 5 columns each values are unique vlaues . i have one column DOM Filter .  DOM filter have combine value and also seperate value . i have attached sample date for reference 

Code    Value 1   value 2  value 3    DOM 

101        5            10           7            A104

101        5            10           7            B104,S104,A104

101        5            10           7            Z104,R104

101        5            10           7            G104,A104

101        5            10           7            O104

101        5            10           7            R104

101        5            10           7            S104,Z104  

 

 

 I  have seperate sheet for DOM filter  

DOM Filter 

A104

B104

Z104

O104

G104

R104

S104

 

If i select  value A104 in  filter value should come from combine value and seperate value . like

 

               VALUE 1         VALUE 2     VALUE 3

A104        15                    30              21 

any idea ?  thanks in advance .

1 REPLY 1
wdx223_Daniel
Super User
Super User

wdx223_Daniel_0-1626939447582.png

 

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors